Bugs series: Skip using IGNORE_ROW_ON_DUPKEY_INDEX Hint in 11.2. Wait until 12c

Skip using IGNORE_ROW_ON_DUPKEY_INDEX Hint in 11.2. Wait until 12c. Your data can be corrupted by letting in duplicate rows.

Patch which might help is 11865420. However if PSU’s are installed on top of 11.2 then patch merge request must be issued to Oracle.

The IGNORE_ROW_ON_DUPKEY_INDEX hint stands on itself – it changes execution semantics. Looks like it is a last minute change in Oracle 11.

 

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s