Silently ignore new rows that violate a single unique index. - The
IGNORE_ROW_ON_DUPKEY_INDEX hint applies only to single-table INSERT operations. It is not supported for UPDATE , DELETE , MERGE , or multitable insert operations. IGNORE_ROW_ON_DUPKEY_INDEX causes the statement to ignore a unique key violation for a specified set of columns or for a SINGLE specified index. - When a unique key violation is encountered, a row-level rollback occurs and execution resumes with the next input row.
- As with all hints, a syntax error in the hint causes it to be silently ignored. The result will be that ORA-00001 will be caused, just as if no hint were used.
RefBulk operations? Multiple rows with same UK being inserted - which get in - arbitrary ? |
0 comments:
Post a Comment