2007年
-
编辑 删除
重建temp表空间
shutdown immediatestartupcreate TEMPORARY tablespace TEMP2 TEMPFILE 'D:ORADATASMSDBTEMP02.DBF' size 5M reuse autoextend on next 10M;ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP2";DROP TABLESPACE TEMP;host del D:ORADATASMSDBTEMP01.DBF;create TEMPORARY tablespace TEMP TEMPFILE 'D:ORADATASMSDBTEMP01.DBF' size 512M reuse autoextend on next 10M;ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP";DROP TABLESPACE TEMP2;host del D:ORADATASMSDBTEMP02.DBF;[@more@]
