Hi,
in my db 11.2.0.4, i'm trying to execute an insert select from in parallel with IGNORE_ROW_ON_DUPKEY_INDEX hint.
Ex:
alter session enable parallel dml;
insert /*+ APPEND PARALLEL(TAB,4) IGNORE_ROW_ON_DUPKEY_INDEX(TAB,PKTAB) */ into
select /*+ PARALLEL(TAB2,4) */ * from TAB2;
looking v$session i see that only 4 P00* are actives.
If I remove IGNORE_ROW_ON_DUPKEY_INDEX, the insert works in parallel.
It's a limitation? Any one has an idea on how to perform massive insert skipping duplicates or rows that can cause ora-1?
Regards