
Today in this article, we will learn how to check default tablespace in Oracle database. Let’s go through the steps :
Table of Contents
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 :

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 :

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