SQL> drop tablespace users including contents and datafiles;
drop tablespace users including contents and datafiles
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
SQL> alter database default tablespace user1;
Database altered.
SQL> drop tablespace users including contents and datafiles;
Tablespace dropped.
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
ORACLE_OCM USER1
OJVMSYS USER1
SYSKM USER1
XS$NULL USER1
GSMCATUSER USER1
MDDATA USER1
AUDSYS USER1
DIP USER1
SYSDG USER1
SPATIAL_CSW_ADMIN_USR USER1
SPATIAL_WFS_ADMIN_USR USER1
GSMUSER USER1
SYSBACKUP USER1
SYSTEM SYSTEM
SYS SYSTEM
Like this:
Like Loading...
Related