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 Comment

Your email address will not be published. Required fields are marked *

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 Comment

Your email address will not be published. Required fields are marked *