The simple process of manually deleting a database to drop the database is as follows: if the database version is 10 Gb or later, it must be in the mount state. In RESTRICTED mode, sys @ STANDBY3 (dtydb5)> shutdown the database has been disabled. The database has been detached. The ORACLE routine has been disabled. Sys @ STANDBY3 (dtydb5)> startup mount; the ORACLE routine has been started. Www.2cto.com Total System Global Area 3140026368 bytesFixed Size 2230600 bytesVariable Size 771753656 bytesDatabase Buffers 2348810240 bytesRedo Buffers 17231872 bytes the database has been loaded. Sys @ STANDBY3 (dtydb5)> drop database; drop database * row 1st error: ORA-12719: operation requires database in RESTRICTED mode sys @ STANDBY3 (dtydb5)> alter system enable restricted session; the system has been changed. Sys @ STANDBY3 (dtydb5)> drop database; the database has been deleted. Note: The drop database command 2, The drop database command deletes these files from operating system can be available for 1, 10 Gb or above. * Datafiles www.2cto.com * 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 file3. files in Windows NT will not be automatically deleted by the author hijk139.