Re: How to delete a database?

Ku Kam Ming wrote:
>
> as title! No drop database statment!!
>
> Thanks,
> --
> **********************************************************************
> Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
> *********************************************************************
>

Basically, you shut down the instance and delete the operating system files. So, you should get a listing of the files in v$logfile, v$datafile, and v$controlfile before you shut down the instance.

Depending on your operating system, you should perform some additional cleanup steps.

UNIX

	Remove the admin directory for this database under
	$ORACLE_BASE/admin (assuming you are using OFA).

	Remove any files for this database in $ORACLE_HOME/dbs

	Remove the database from the oratab file ( /etc/oratab in HP-UX,
	/var/opt/oracle/oratab in Solaris)

	Remove any references to the instance from your listener.ora
	file and restart any v2 listeners that contained it. 

VMS         Remove the ORA_DB directory.

        Edit ORA_RDBMS:ORA_RDBMS_SIDS.DAT to remove the instance.

        Edit ORA_UTIL:DATABASE.TXT to remove the database

	Edit TNS_ADMIN:LISTENER.ORA to remove the instance from any
	listeners. Restart the listeners.

Hope this helps.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com