DROP DATABASE statement conditions - Oracle Datafiles and Tempfiles

Q.  The DROP DATABASE statement deletes all control files and all other database files listed in the control file, to use the DROP DATABASE statement successfully, which conditions must apply?
- Published on 03 Aug 15

a. The database must be mounted and closed
b. The database must be mounted exclusively--not in shared mode
c. The database must be mounted as RESTRICTED
d. All mentioned above

ANSWER: All mentioned above


  • Nirja Shah   -Posted on 25 Sep 15
    - You cannot roll back a DROP DATABASE statement.

    - Use the DROP DATABASE statement to drop the database.

    - This statement is useful when you want to drop a test database or drop an old database after successful migration to a new host.

    - You must have the SYSDBA system privilege to issue this statement. The database must be mounted in exclusive and restricted mode, and it must be closed.

    - Syntax

    - When you issue this statement, Oracle Database drops the database and deletes all control files and datafiles listed in the control file.

    - If the database used a server parameter file (spfile), it is also deleted.

    - Archived logs and backups are not removed, but you can use Recovery Manager (RMAN) to remove them.

    - If the database is on raw disks, this statement does not delete the actual raw disk special files.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)