Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to drop schema objects without dropping user in one pass?

471462Jan 19 2006 — edited Jan 19 2006

HI,

I am after some PL/SQL that can drop all the objects that a user has, without dropping the user himself.

I can write a query that spool SQL to a script to drop all the appropriate objects, but it has to be run multiple times as some things can not be dropped before other objects which may appear later in the script.

I want a script that developers can run once to drop all their objects.

Can anyone point me in the right direction?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2006

Added on Jan 19 2006

#general-database-discussions

4 comments

14,119 views