1、确定要删除的数据库 SQL> show parameter instance_name;
NAME TYPE VALUE
instance_name string THCZY 2、一致性关闭数据库 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 3、启动数据库到限制排它模式 SQL> startup restrict exclusive force mount; ORACLE instance started.
Total System Global Area 8752005120 bytes Fixed Size 2253456 bytes Variable Size 1979714928 bytes Database Buffers 6744440832 bytes Redo Buffers 25595904 bytes Database mounted. SQL> show parameter instance_name;
NAME TYPE VALUE
instance_name string THCZY
4、删除收据库 SQL> drop database;