(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)


--
_______________________
/_____________________(_)

"Peter Morris" <nospam.ple (AT) se (DOT) com> wrote

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

"DJ" <nospamplease (AT) goaway (DOT) com> wrote



More information, please. What's oradim -delete? What tool
do I run it in?

Peter Morris wrote:
If you don't grok oradim you might consider going to
http://docs.oracle.com and searching for the term.

It's a 'DOS box' kinda thing.

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]

Hans Forbrich wrote:
Oh, and you might go to http://otn.oracle.com and look at the 'Sample
Code' icon at the top. Search for 'Oracle by Example' and look at the
examples. They have step by step instructions, including screen shots,
on both install and complete delete (delete so you can start the next
example on a 'clean machine').

While each example is for a specific version of the software (database,
tools, etc.) using a little bit of imagination and minimal skull sweat,
a person could likely 'translate' the information to most supported
versions.


--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]

Hans Forbrich wrote:


Go to the Oracle bin directory ... likely something like c:\oracle\ora92\bin

There you will see an executable named oradim.exe

At the DOS prompt type oradim and it will give you the syntax to drop
the services.

Of course you could just edit the registry to accomplish the same thing
but oradim is a whole lot safer.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)