How to drop a full Schema/user?

Toad for Oracle & DevOps Toolkit
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.

2

Very carefully.

3

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.

4

Just drop the user. Do not forget cascade.

And you better know what you are doing.

5

FIRST DO A FULL BACKUP and STORE THAT BACKUP SOMEWHERE SAFE.

Then follow the advice that Bert and Jeff provided

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.