Re: delete / drop database

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 23 Feb 2000 18:57:09 +0800
Message-ID: <38B3BD05.7CD3@yahoo.com>

Angie wrote:
>
> hi, all
>
> i'm new to oracle but familiar with sybase and ms sql.
>
> i've no idea how to delete a database (on NT, 8.0.5). i've created
> severals databases but while creating them i'm never asked for the
> internal id/passwort which is then required for deletion.
>
> what statement shows me all databases in the DBMS? (in sybase, sp_help
> and sp_helpdb gives you lots of useful details, but i haven't found
> anything like this in oracle)
>
> anyone any idea or suggestion for a beginners documentation (the oracle
> documentation hasn't provided any help)?
>
> thank you,
> angie

There will entries for each database in Services which will tell what databases are running.

To remove a database, you can

select * from v$datafile
select * from v$controlfile
select * from v$logfile

to find all the various files that need to be deleted.

Then

- shut your db abort
- remove the files
- remove the services entries using regedit

HTH
--

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Wed Feb 23 2000 - 04:57:09 CST