Database 11g

Thursday, April 14, 2016

How to check default tablespace in oracle



SQL> SELECT * FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE '%TABLESPACE%';


PROPERTY_NAME                              PROPERTY_VALUE                DESCRIPTION
------------------------------ -------------------- ---------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE                TEMP                  Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE   USERS               Name of default permanent tablespace



Happy Learning ....









No comments:

Post a Comment