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!

drop all objects owned by schema

user246075Jun 30 2011 — edited Aug 30 2012

Hi,

Can any one help to get script to drop all objects, including any LOB objects, owned bye schema

SQL> select distinct object_type from dba_objects where owner='YOUTELE';

OBJECT_TYPE
-------------------
INDEX
TABLE
VIEW
LOB

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2012

Added on Jun 30 2011

#general-database-discussions

23 comments

25,405 views