If you don't have system level access, and want to clean your oracle schema, the following sql will produce a series of drop statments, which can then be executed. Not all of them will execute - if you drop with cascade, dropping the PK_* indices will fail.
select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLEConfirm with:
select * from user_objectsPurge out the recyclebin if not needed:
purge recyclebin;Bookmark/Search this post with
- sandip's blog
- Login or register to post comments