Community

DBA_INDEXES shows no index but Create Index errors out with ORA-01408: such column list already indexed

by SSWUG Research

(Anand) Yesterday we had a very interesting issue popped up on 10.2.0.5 database where the team running a sql script got gORA-01408: such column list already indexedh though the dba_indexes showed no index on the table.The index to be created was gtest_u1

Read More - Register for Free Membership

Tags:
Author: SSWUG ResearchSSWUG Research is the team that brings you SSWUG-based content and community links. Have an idea? Send us a note at sswugresearch@bitsonthewire.com - we'd love to hear from you.