删除数据库的方法
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 bytesFixed Size1345296 bytesVariable Size973080816 bytesDatabase Buffers654311424 bytesRedo Buffers11747328 bytes
SQL> alter database mount exclusive; 将数据库设置为受限模式Database altered.
SQL> drop database; 删除数据库Database dropped.
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 bytesFixed Size1345296 bytesVariable Size973080816 bytesDatabase Buffers654311424 bytesRedo Buffers11747328 bytes
SQL> alter database mount exclusive; 将数据库设置为受限模式Database altered.
SQL> drop database; 删除数据库Database dropped.
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。