Perşembe

how to create a new temporary tablespace

First create a new temp tablespace. Yes, unlike the undo tablaspace, you can have more than one temp tablespace -but only one of them could be database default temporary tablespace at once.

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;
 
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