Thursday, August 27, 2009

Default temproary tablespace in Oracle

Use this query to find the default temproary tablespace in an Oracle database.

SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

No comments: