Step:1 CREATE TEMPORARY TABLESPACE tempnew TEMPFILE '/u02/oracle/data/lmtemp01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M; Step:2 ALTER DATABASE DEFAULT TEMPORARY TABLESPACE tempnew; Step:3 ALTER DATABASE TEMPFILE 'TEMPOLD' OFFLINE; Step:4 DROP TABLESPACE TEMPOLD;
Advertisements