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!

How to drop several indexes

916718Feb 10 2012 — edited Feb 13 2012
Hi.
Could anybody tell me how can i drop several bad indexes.
There are lots of indexes to columns which have duplicated values. I need to drop these all indexes. but not in manual way like
"
drop index one;
drop index two;
"

Is there some way of inserting a select statement into drop? And how to run it for all tables in schema?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2012
Added on Feb 10 2012
14 comments
6,797 views