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 Recover a Dropped Index?

Think_dbaApr 26 2012 — edited Apr 26 2012

oracle version:11.2.0.1
OS: windows server 2008

When we flashback the table its associated index will remain in the recyclebin.Right? then how can we recover them?

1.)alter index <recyclebin_index__name> rename to <orginal_name> ;

2.)alter index <index_name> rebuild;

but incase if have a big table having more than 300 indexes(for eg) then what will be the method to recover them?

This post has been answered by Aman.... on Apr 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2012

Added on Apr 26 2012

#general-database-discussions

11 comments

4,003 views