Re: Drop database on Oracle 9i

"Odd B Andersen" <obande_at_online.no> wrote in message news:491c0f79$0$90276$14726298_at_news.sunsite.dk...
> As you may understand I'm new to Oracle :-)
>
> But I wish to drop a database on Oracle 9i, but cannot find a 'drop
> database' command, like I find in versjon 10g. How can I drop my database?
> This is on Solaris, and I cannot use any GUI tools (DBCA).
> --
> Regards
>
> Odd Bjørn Andersen
> ErgoGroup AS
> Postboks 4364 Nydalen, N-0402 Oslo, Norway
> Telefon +4723 14 50 00, Telefaks +4723 14 50 01
> Mobilnr +47970 84597
> www.ergogroup.no
>
>

First make sure that is really what you want to do. In most RDBMS's a database is a logical collection of related database objects. (eg MS Sql Server, mysql) In those RDBMS's you have one instance of the RDBMS running with multiple databases. (master, northwind, etc.) Oracle does NOT work that way. Dropping the database in Oracle means you want to destroy EVERYTHING - the entire Oracle instance. It is rare you want to do that. Instead Oracle has a concept called schemas. It is likely that you want to drop a schema. That is more common. (okay ,not all that common, but more common htan dropping the whole database, which is equivalent to rm -rf * for the db)

I believe the command is drop schema. See the SQL Reference manual that came with the db or go to otn.oracle.com and download the manual. Jim Received on Thu Nov 13 2008 - 09:08:17 CST