临时表空间的数据文件如何缩小？

hbwp2008

原帖由 NinGoo 于 2008-4-5 08:42 发表
tempfile是可以drop的

我的DROP TEMPFILE 时出错!!!

Creating archive destination LOG_ARCHIVE_DEST_1: 'E:ARCHIVELOGARC94134.94134.LOG'
ARC0: Completed archiving  log 4 thread 1 sequence 94134
Sat Apr 05 10:36:05 2008
CREATE TEMPORARY TABLESPACE TEMP02 TEMPFILE
'D:ORACLEORADATAXXXXTEMP02.DBF' SIZE 3072M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
Sat Apr 05 10:36:05 2008
Completed:  CREATE TEMPORARY TABLESPACE TEMP02 TEMPFILE
'D:O
Sat Apr 05 10:37:19 2008
alter database default temporary tablespace TEMP02
Sat Apr 05 10:37:19 2008
Completed: alter database default temporary tablespace TEMP02
Sat Apr 05 10:37:52 2008
drop tablespace TEMP including contents and datafiles
Sat Apr 05 10:37:53 2008
Errors in file dracledbadminecsmudumpecsm_ora_6028.trc:
ORA-01258: unable to delete temporary file D:ORACLEORADATAXXXXTEMP01.DBF
ORA-27056: skgfrdel: could not delete file
OSD-04024: 無法刪除檔案.
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

Completed: drop tablespace TEMP including contents and datafi
Sat Apr 05 10:39:04 2008
drop tablespace TMPDATA including contents and datafiles
Sat Apr 05 10:39:05 2008
Errors in file dracledbadminecsmudumpecsm_ora_6028.trc:
ORA-01258: unable to delete temporary file D:ORACLEORADATAXXXXTMPDATA07.DBF
ORA-27056: skgfrdel: could not delete file
OSD-04024: 無法刪除檔案.
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

hbwp2008

drop tablespace TEMP including contents and datafiles

我見這樣没有删除数据文件. 我手动删除啦. 报上错. 不知道什么原因?

棉花糖ONE

http://rollingpig.itpub.net/post/81/88076