Re: Drop database on Oracle 9i

On 13 Nov, 15:08, "gym dot scuba dot kennedy at gmail" <kenned..._at_verizon.net> wrote:
> "Odd B Andersen" <oba..._at_online.no> wrote in messagenews: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- Hide quoted text -
>

Good point Jim. I assumed (and I _hate_ people making assumptions) that, as the OP mentioned 10g and the drop database command, he was aware of the concept of an Oracle database.

As for dropping a schema I do it as follows:

DROP USER <user/schema name> CASCADE;

HTH -g Received on Thu Nov 13 2008 - 09:14:54 CST