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!

issues with IGNORE_ROW_ON_DUPKEY_INDEX..

844593Apr 7 2011 — edited Apr 7 2011

Oracle version: 11.2.0.2 on both linux & windows

insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(TABLE1, TABLE1_PK) */
into table1 (column1, column2) values('AAA', 'BBB');

ERROR at line 1:
ORA-00001: unique constraint (TABLE1_PK) violated

'coulmn1' is a PK.

Not supposed to get the above error. Any hints?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2011

Added on Apr 7 2011

#11g, #general-database-discussions, #oracle

2 comments

896 views