Drop database on Oracle 9i

[Odd B Andersen]

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

[gazzag]

Prior to 10g, dropping a database consisted of shutting the instance
down and manually removing its associated datafiles, logs, control
files and associated init.ora file at operating system level. You
might also want to remove any reference to it in /etc/oratab or /var/
opt/oratab.

HTH

-g

[gym dot scuba dot kennedy at gmail]

"Odd B Andersen" <oba...@online.no> wrote in message
news:491c0f79$0$90276$1472...@news.sunsite.dk...

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

[gazzag]

On 13 Nov, 15:08, "gym dot scuba dot kennedy at gmail"
<kenned...@verizon.net> wrote:
> "Odd B Andersen" <oba...@online.no> wrote in messagenews:491c0f79$0$90276$1472...@news.sunsite.dk...

> 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