D]>
cc:
Subject: Re: dropping a user's objects
Bill,
Pull out the big cannon and go boom:
export the CREATE USER to create_user script
write a script containing:
DROP USER uname CASCADE;
@CREATE_USER
run this new script.
have beer.
Now of course, this wi
I like how you think
-Original Message-
Sent: Thursday, August 08, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
Bill,
Pull out the big cannon and go boom:
export the CREATE USER to create_user script
write a script containing:
DROP USER uname CASCADE;
@CREATE_USER
run t
t; <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/08/2002 11:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: dropping a user's objects
Good day, all:
I have a PL/SQL routine that
Bill,
Pull out the big cannon and go boom:
export the CREATE USER to create_user script
write a script containing:
DROP USER uname CASCADE;
@CREATE_USER
run this new script.
have beer.
Now of course, this will not be as fast as a parallel
DROP TABLE user.tab CASCADE CONSTRAINTS, but hey,
pients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: dropping a user's objects
Good day, all:
I have a PL/SQL routine that I use to drop all objects owned by a given
user, which I'm attaching below.
I first drop primary keys, then unique constraints