APEX

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-00957: duplicate column name when trying >create index

829637Aug 10 2011 — edited Aug 10 2011

Hi all,

I hope this is the correct location for this question!

I have been instructed to execute the following command (by PTC, the manufacturer of the 3rd party tool sitting on top of Oracle), as the db User for their product:

sql>create index EPMFAMILYTABLECELL$PTC2 on EPMFAMILYTABLECELL(idA3A3,idA2A2, classnameA2A2, idA3A3, classnamekeyB3, idA3B3, defi
nedHere, inherited) compress 1

There are actually 4 total to be created, the structure of the command is very similar, two indexes on each of two tables. All four commands cause Oracle to gripe "ERROR

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2011

Added on Aug 10 2011

#apex-discussions, #error, #index

6 comments

1,338 views