ORA-12919- Can not drop the default permanent tablespace
删除users表空间时出现以下错误
数据库版本
SQL> select * from v$version ;BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
错误
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> create tablespace gqxt datafile'/oradata/gqxt/gqxt01.dbf' size 1024m;Tablespace created.SQL> alter database default tablespace gqxt ;Database altered.SQL> drop tablespace users including contents and datafiles ;Tablespace dropped.