From: Sridhar Subramaniam <avion@ozemail.com.au>
Subject: Re: deleting all database objects belonging to a user
Date: 1995/11/11
Message-ID: <30A59177.5919@ozemail.com.au>#1/1
references: <RSZ.95Nov10083604@aifbodette.aifb.uni-karlsruhe.de>
content-type: text/plain; charset=us-ascii
organization: Avion Consulting & Services Pty Ltd
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.0b2a (Windows; I; 16bit)


Roland Schaetzle wrote:
> 
> Hallo,
> 
> 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).
> 
> Roland
> 
> 
 ----------------------------------------------------------------------
> Roland Schaetzle                email: 
 schaetzle@aifb.uni-karlsruhe.de
> Institut AIFB                   Tel. : +49-721-608-4061
> Universitaet Karlsruhe
> ----------  D-76128 Karlsruhe -- Englerstr.11 -- Raum 229 
-----------
Roland,
How about 'drop user xxx cascade' and then recreating the user.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama@nibucorp.ccdn.otc.com.au / avion@ozemail.com.au

Disclaimer : All opinions are truly and just mine.