Sunday, July 13, 2008

Oracle tempfile creation if the current one is full

CREATE
TEMPORARY TABLESPACE "TEMP1" TEMPFILE
'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TEMP02.DBF' SIZE 200M
REUSE AUTOEXTEND
ON NEXT 640K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM
SIZE 1024K;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP1";

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

No comments: