Skip to Main Content

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!

wildcard drop statement

2817999Dec 19 2014 — edited Dec 23 2014

Hello.

I have SQL developer/SQLplus. I need to drop all users, tables, schemas, views & all related objects/records (if poss.)

which begin with ora_. Can anyone please help me with the SQL statements & procedures to do so?

Thanks!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2015
Added on Dec 19 2014
7 comments
2,345 views