手工drop database的步骤
手工删除oracle database
1先关闭数据库
shutdown immediate;
2启动实例并加载数据库
startup mount;
3将例程置于受限模式
alter system enable restricted session;
4删除库
drop database
注：必需在专用连接模式下操作
摘录altert.log中信息如下：
drop database
Tue Feb 09 10:36:07 2010
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\SYSTEM01.DBF
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\UNDOTBS01.DBF
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\SYSAUX01.DBF
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\USERS01.DBF
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\REDO01.LOG
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\REDO02.LOG
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\REDO03.LOG
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\TEMP01.DBF
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\CHANGED_BLOCKS.BCT
Instance terminated by USER, pid = 1296
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\CONTROL01.CTL
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\CONTROL02.CTL
Deleted file D:\ORACLE\PRODUCT\10.2.0\ORADATA\INFOSOFT\CONTROL03.CTL
Completed: drop database
Tue Feb 09 10:36:14 2010
Shutting down instance (abort)
License high water mark = 1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/777981/viewspace-627119/ ，如需转载，请注明出处，否则将追究法律责任。
