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;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment