Re: deleting all database objects belonging to a user
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/11/10
Message-ID: <Pine.SUN.3.91.951110112034.8403G-100000_at_seatimes>#1/1
Date: 1995/11/10
Message-ID: <Pine.SUN.3.91.951110112034.8403G-100000_at_seatimes>#1/1
On 10 Nov 1995, Roland Schaetzle wrote:
> how can I delete (drop) all database objects belongig to a
> certain user in a simple way, i.e. I don't want to issue
> a 'drop xxx' command for ervery object (there are hundreds
> of those objects).
ORACLE won't allow you to drop the user until all the objects in that schema are removed. They do provide the CASCADE option on the DROP USER x command.
So,
DROP USER x CASCADE;
Will drop that user and all objects in that user's schema.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Fri Nov 10 1995 - 00:00:00 CET