Re: Script to drop all the tables
From: <nwaldie_at_my-deja.com>
Date: Fri, 22 Sep 2000 15:41:31 GMT
Message-ID: <8qfuj6$3jf$1_at_nnrp1.deja.com>
Date: Fri, 22 Sep 2000 15:41:31 GMT
Message-ID: <8qfuj6$3jf$1_at_nnrp1.deja.com>
Unless that user owns something else which you wish to preserve, I like "drop user xxxx cascade;" then recreate the user account.
corrections 7 comments welcome
nwaldie_at_technologist.com
In article <2AAy5.11166$WK6.178092_at_typhoon.austin.rr.com>,
"Darwin Ling" <darwin_ling_at_hotmail.com> wrote:
> I would like to write a script to drop all tables and sequences that
belong
> to a user in Oracle 8i
>
> What would be the easiest way to do this instead of doing
> drop table xxx explicitly for all tables?
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 22 2000 - 17:41:31 CEST