删除数据库的方法

1.使用dbca

2.使用sql语句删除

SQL> shutdown immediate;   关闭数据库

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount restrict;       切换到nomount模式且为exclusive模式

ORACLE instance started.

Total System Global Area 1640484864 bytes

Fixed Size            1345296 bytes

Variable Size          973080816 bytes

Database Buffers      654311424 bytes

Redo Buffers           11747328 bytes

SQL> alter database mount exclusive;   将数据库设置为受限模式

Database altered.

SQL> drop database;  删除数据库

Database dropped.