Temp tablespace


CREATE TEMPORARY TABLESPACE temp_n TEMPFILE '/u01/oracle/oradata/NIDEV/temp_01.dbf' SIZE 500M
autoextend off extent management local UNIFORM SIZE 1M;

alter database default temporary tablespace temp_n;



col PROPERTY_VALUE for a40
col DESCRIPTION for a40
select * from database_properties;