DROP A DATABASE IN ORACLE

High level steps of database drop in oracle

Shutdown the database instance

SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Startup database in exclusive restrict to block incoming client connections to the database

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 1169149952 bytes
Fixed Size                  2252624 bytes
Variable Size             385876144 bytes
Database Buffers          771751936 bytes
Redo Buffers                9269248 bytes
Database mounted.

Drop the database

SQL> drop database;

Database dropped.

Then you can use dbca to delete the SID and other entries from the server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s