Syntax to Find / Check / Change / Set Default Permanent Tablespace for Oracle 10g, 11g Database

Default Permanent tablespace Syntax
SQL> create tablespace default_tbs datafile '/u01/app/oracle/oradata/dbrepoinf/default_tbs.dbf' size 100m;

Tablespace created.

SQL> alter database default tablespace default_tbs;

Database altered.

SQL> select * from database_properties where property_name like 'DEFAULT_PERMANENT_TABLESPACE';
Name of default permanent tablespace

You cannot drop the default permanent tablespace you will get following error.
SQL> drop tablespace DEFAULT_TBS;
drop tablespace DEFAULT_TBS
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google