Timeline for Oracle hint failure
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 11, 2013 at 9:45 | comment | added | David Aldridge | @user10478 The syntax for the table(column) part of the hint looks similar to that used for the index hint, for which the documentation states to specify the table name without schema name, or the alias if one is used. I'm not sure whether aliases are accepted for single table inserts (the docs suggest that they are) but it would be interesting to see whether the hint needs the alias to be used if one is specified. | |
| Sep 2, 2012 at 17:49 | comment | added | user10478 | INSERT /*+ IGNORE_ROW_ON_DUPKEY_INDEX(Clue(ID))*/ INTO Sandbox.Clue | |
| Sep 2, 2012 at 17:49 | vote | accept | user10478 | ||
| Aug 2, 2012 at 20:13 | comment | added | user10478 | Interesting, the hint appears to work only when the table name is NOT qualified by the schema name. I assume you noticed the same, as you omitted schema name completely from the code. | |
| Aug 1, 2012 at 7:40 | history | answered | user953 | CC BY-SA 3.0 |