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;
Showing posts with label temp tablespace. Show all posts
Showing posts with label temp tablespace. Show all posts
Sunday, July 13, 2008
Subscribe to:
Posts (Atom)