How to check default tablespace in Oracle Database : 2 Easy Steps

check default tablespace in Oracle
Today in this article, we will learn how to check default tablespace in Oracle database. Let’s go through the steps :

Step 1: Check default tablespace in Oracle

Issue below command to check default tablespace

SELECT PROPERTY_VALUE
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE';

Output :

check default tablespace in Oracle

Step 2: Check default temporary tablespace in Oracle

Issue below command to check default temporary tablespace in Oracle

SELECT PROPERTY_VALUE
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'DEFAULT_TEMP_TABLESPACE';

Output :

check default tablespace in Oracle

Hope this helps!! Also, you can get more details related to tablespace from the Oracle Doc as well.

In the next article, you can get How to Check Default Tablespace For User

Leave a Reply