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!

ORA-01408: such column list already indexed

626362Mar 13 2008 — edited Mar 13 2008

If I'm creating a multi-column index for one table and I get the message

"ORA-01408: such column list already indexed"

because there's an index already there for a similarly named "backup table" for the same column names can I use that index for this table somehow? What is the workaround besides dropping the index that's already there?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2008

Added on Mar 13 2008

#general-database-discussions

12 comments

30,041 views