Re: Drop Database.

To get rid of the database so that you can recreate it, do the following.

Shutdown the database.

1. Delete all datafiles.
2. Delete all online redo log files.
3. Drop all control files.
4. If you are running database in archivelog mode, delete all archived log files realted to this database from archive log destination.

Delete all these files from the disk using operating system delete/remove command you normally would use to delete a file.

If you know all these files already then simply delete them when the database is in shutdown state.

If you don't know the list start the database and get the information running foillowing queries.

1. Query v$datafile to list all datafiles.

            select * from v$datafile;

2. Query V$logfile to list online redo log files.

            select * from v$logfile;

3. Query v$controlfile to list all the controlfiles.

            select * from v$controlfile;

Once you identified these files, shutdown normal/immidiate/abort the database.

Go to operating system all delete these files.

Once you have deleted these files you have basically gotten rid of the database.

You can now recreate the database from scratch.

Hope this helps,

Manoj Jain
Chauncey Certified Oracle7 DBA
Oracle Certified Professional OCP DBA

In article <35E9E794.7E43_at_pacbell.net>,   sanjeev_at_pacbell.net wrote:
> Hi,
>
> I have a corrupted data block in Rollback segment. I was able to take
> full export. I am trying to drop my database. Can anyone tell me right
> syntax to drop the database, then i can create new dB and import the dmp
> file.
>
> Thanks,
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 31 1998 - 00:26:33 CDT