SQL & PL/SQL

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!

Renaming index after flashback

784735May 31 2011 — edited Jun 1 2011

Hi,
I dropped one table from my database, but managed to get it back with flashback. But my table had an index on one of the columns. When i flashback the table index name is created as shown below.

BIN$mRdqJ8/PGDPgRAAhKBeoSg==$0

I tried to drop this index(because its name is incorrect) but am not able to do. It looks like the == characters are causing problem in treating it as an identifier.

Any way to drop the index and recreate it.

Please advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2011

Added on May 31 2011

6 comments

515 views