Manually delete the database drop database
the
The simple process is as follows, above version 10g, the database must be in the mount state, in RESTRICTED mode
sys@STANDBY3(dtydb5)> shutdown
The database has been closed.
The database has been unmounted.
The ORACLE instance has been shut down.
sys@STANDBY3(dtydb5)> startup mount;
The ORACLE instance has been started.
www.2cto.com
Total System Global Area 3140026368 bytes
Fixed Size
Variable Size 771753656 bytes
Database Buffers 2348810240 bytes
Redo Buffers
The database is loaded.
sys@STANDBY3(dtydb5)> drop database;
drop database
*
Error on line 1:
ORA-12719: operation requires database to be in RESTRICTED mode
the
sys@STANDBY3(dtydb5)> alter system enable restricted session;
the
The system has changed.
sys@STANDBY3(dtydb5)> drop database;
the
The database has been deleted.
the
illustrate:
1. Only 10g or more can have the drop database command
2. The DROP DATABASE command deletes these files from operating system.
* Datafiles www.2cto.com
* Online Redo Log Files
* Controlfiles
* SPFILE (if it exists)
the
The DROP DATABASE command does not delete the following files:
* init.ora (text version of the Oracle initialization file)
* password file
* entries in listener files
* entries in oratab file
3. Files will not be deleted automatically under win NT environment
the
the
Author hijk139
Manually delete the database dropdatabase
This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/manually-delete-the-database-dropdatabase/