CREATE TEMPORARY TABLESPACE TEMP4 TEMPFILE '/oracleAS/TPRS/oradata/TPRS/temp4.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
now change the database default tablespace
alter database default temporary tablespace TEMP4;
get rid of the the old one!
drop tablespace TEMP1 including contents
Hiç yorum yok:
Yorum Gönder