Showing posts with label default temp tablespace. Show all posts
Showing posts with label default temp tablespace. Show all posts

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