Re: delete / drop database

Two things:
- databases in MS SQL Server are more logical databases (the master database is separate from them). In Oracle, you have "schemas", mapped to users, that hold logical information and that can be backed up individually. But they all belong to the same database as such. If you connect as a Administrator, "select username from dba_users" will yield a list of these schemas... "drop user myuser cascade" will drop a schema and all its objects.

• if you have several databases, created with a wizard or something, the INTERNAL account is using the ORACLE password by default, unless you specified otherwise in some arcane command line utility...

Hope this helps!

--
JP Moresmau
jpmor_at_gofree.indigo.ie
http://frenchstud.io
Angie <m_antje_at_gmx.de> wrote in message news:38B3F144.735376A1_at_gmx.de...
> 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
Received on Wed Feb 23 2000 - 13:03:50 CST