Thinking Out Loud

September 19, 2007

drop database

Filed under: oracle — mdinh @ 9:40 pm

Note: I had to modify the screen shot to remove domain name of the company.

The drop database command can be useful in a testing environment for cleaning up data files, controlfiles, and log files.


Note: database must be mounted EXCLUSIVE and not open for this operation.


One disappointment is that it did not delete the directory beneath DIAGNOSTIC_DEST.

Here are all the directories still left behind.


This is what I executed to remove the remaining directories in my environment.

find /ora* -user oracle -type d -name PRIME -exec rm -rfv {} \;

ALWAYS be careful when using rm -rf command.


1 Comment »

  1. […] Dinh shows how to drop database (don’t try this on […]

    Pingback by Links of the Week - #4 « I’m just a simple DBA on a complex production system — February 1, 2008 @ 6:59 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

You are commenting using your 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at

%d bloggers like this: