Re: Drop Database

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 12 Mar 2002 11:10:42 +0100
Message-ID: <3C8DD422.504F17C@mytoys.de>

> I am relatively new to Oracle and was wondering how to drop a
> database/schema as you can in Sybase?

Dropping a schema means dropping a user with

drop user <username> [cascade];

Dropping a database means shutting down the instance and deleting every database file, control file, redo log file, archived log file, init.ora, tnsnames.ora entry, listener.ora entry, oratab entry. Or you use the database creaion assistant, which can also delete a database.

Regards,

Knut Received on Tue Mar 12 2002 - 04:10:42 CST