Skip to Main Content
Forums

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

VinodN76Jun 26 2015 — edited Jun 26 2015

Hi All,

I am getting this error while upgrading my EBS 11.1.0.7 database to 11.2.0.4. I checked in the log and it shows:

create index system.repcat$_audit_column_f2_idx on

2  system.repcat$_audit_column(base_sname,base_oname,base_conflict_type_id,

3  base_reference_name)

4  /

system.repcat$_audit_column(base_sname,base_oname,base_conflict_type_id,

*

ERROR at line 2:

ORA-01408: such column list already indexed

Now what I would like to know is whether I should cancel the dbua session, startup the database, drop the index and again start dbua session?

Regards,

Vinod
This post has been answered by top.gun on Jun 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2015
Added on Jun 26 2015
#database-upgrade
2 comments
2,408 views