Guest
February 10, 2010, 5:32am
1
How can I drop a full schema/user (with all depending TABLEs, VIEWs, OBJECTs)
?
Ben
View this message in context: http://old.nabble.com/How-to-drop-a-full-Schema-user--tp27529750p27529750.html
Sent from the TOAD mailing list archive at Nabble.com .
You simply choose that user on the schema browser users tab – do a right
hand mouse and choose drop (or choose the drop toolbar icon). It will ask you
things like are you sure, and cascade – cascade means all objects owned by
that schema.
Just drop the user. Do not forget cascade.
And you better know what you are doing.
Patrick
February 10, 2010, 8:38am
5
FIRST DO A FULL BACKUP and STORE THAT BACKUP SOMEWHERE SAFE.
Then follow the advice that Bert and Jeff provided
Guest
February 10, 2010, 9:23am
6
Hey Ben,
How can I drop a full schema/user (with all depending TABLEs, VIEWs,
OBJECTs)
?
Seriously, I'd start here: http://tinyurl.com/y9e7s8m
GL!
Rich -- [TeamT]
Disclaimer: I've taken about 10 of those.