CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE
'/afs3/app/oracle/oradata/P755/temp2_01.dbf' SIZE 100M AUTOEXTEND ON MAXSIZE 3700M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2
DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/afs3/app/oracle/oradata/P755/temp.odb' SIZE 100M AUTOEXTEND ON MAXSIZE 32767;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;
No comments:
Post a Comment