next up previous contents
Next: Poking around inside Oracle Up: Oracle Basics Previous: Stopping the database   Contents

Destroy the database

Databases can be deleted like any other object, using the DROP SQL statement. In order to drop the database it must be mounted and closed, mounted exclusively (not in shared mode) and flagged as RESTRICTED. The easiest way to do this is using EM (but then most things are). Once your database is in the proper state, just issuing the SQL "drop test" will destroy the test database we created.