Re: deleting a database

From: DJ <nospamplease_at_goaway.com>
Date: Mon, 20 Oct 2003 00:06:54 +0100
Message-ID: <nOEkb.3971$KA5.34820@newsfep4-glfd.server.ntli.net>

"Peter Morris" <nospam.ple_at_se.com> wrote in message news:bmut54$4p2$1_at_titan.btinternet.com...
> (repost)
>
> How do I delete a database in Oracle?
>
> I posted this question recently, but replies wondered if
> I knew what 'database' means in Oracle.
>
> I've created several databases using the 'create a database'
> option in Oracle Database Configuration Assistant.
> Now I want to delete them. I've tried using the 'delete a database'
> option, but it doesn't work. The folder for the database is still
> taking up disk space in oracle/oradata and the database is still in
> the tree in Oracle DBA Studio, although it seems to be inaccessible.
>
> How do I get rid of unwanted databases completely?
>
> (I'm using Oracle 8i Personal Edition on WinXP)
>
>
> --
> _______________________
> /_____________________(_)
> | _____________________ email to
> | | |__________________(_) Peter_Morris_1 at
> | |/____________________ btinternet dot com
> |_____________________(_)
>
>
>

Shutdown the service, use oradim -delete to delete the service, then you can delete all datafile redp logs control files and anything else associated with that database.

Then youcan be sure it's gone sinceyou have deleted it yourself Received on Sun Oct 19 2003 - 18:06:54 CDT