11g删库和12C删除CDB容器的方式一样:
第一种:dbca图形化
第二种:drop database;
[oracle@suntao ~]$ export ORACLE_SID=db01
[oracle@suntao ~]$ sqlplus / as sysdba
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1593835520 bytes
Fixed Size 8793256 bytes
Variable Size 1023411032 bytes
Database Buffers 553648128 bytes
Redo Buffers 7983104 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode
SQL> alter system enable restricted session;
--打开会话受限模式,需启动到mount状态,等同于 startup restrict exclusive force mount;
System altered.
SQL> drop database; --一个实例就一个库,命令不用写库名
Database dropped.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
11g删库和12C删除CDB容器
最新推荐文章于 2021-04-03 03:34:01 发布