Check default temp tablespace

col PROPERTY_NAME format a50
col PROPERTY_VALUE format a50
col DESCRIPTION format a50
set lin 300
SELECT PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Leave a Reply

Check default temp tablespace

col PROPERTY_NAME format a50
col PROPERTY_VALUE format a50
col DESCRIPTION format a50
set lin 300
SELECT PROPERTY_NAME,PROPERTY_VALUE,DESCRIPTION FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Leave a Reply

%d bloggers like this: