I did not know this command before until someone mentioned to me the other day! I am used to manually dropping databases on UNIX.
Anyhow, here is some info about this command.
Anyhow, here is some info about this command.
DROP DATABASE
The DROP DATABASE command deletes these files from operating system.
* Datafiles
* Online Redo Log Files
* Controlfiles
* SPFILE (if it exists)
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
If the operating system is Windows, then it does not delete the Windows service for the target database instance.
* Datafiles
* Online Redo Log Files
* Controlfiles
* SPFILE (if it exists)
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
If the operating system is Windows, then it does not delete the Windows service for the target database instance.
Reference: Drop Database Command Versus Remove an Oracle Database Manually [ID 443822.1]
No comments:
Post a Comment