Re: delete / drop database

On NT, I've always found the "dbassist" utility to be very helpful. It is located in $ORACLE_HOME/bin. It is a graphical tool that allows you select databases and drop them. It even deletes the files for you. I would try this first.

In article <38B3F144.735376A1_at_gmx.de>,
  Angie <m_antje_at_gmx.de> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 23 2000 - 16:37:36 CST