OraFAQ Forum: SQL & PL/SQL » Parallel hint issue

Home » SQL & PL/SQL » SQL & PL/SQL » Parallel hint issue (oracle 11g / unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Parallel hint issue [message #623397]

Tue, 09 September 2014 22:18

balaji123
Messages: 29
Registered: October 2009
Location: sanfrancisco

Junior Member

below sql very often fails with duplicate rows error message. We have oracle11g rac implementation. we dont have duplicate rows in the result set.
Is there any restriction to use parallel hint on DML operations? Please advice.
Thanks in advance.

INSERT /*+ append parallel(a) */
INTO rate_table a
(
cycle_date ,
isn ,
source ,
serial_rej ,
)
SELECT run_date ,
isn ,
source ,
serial_rej ,
FROM stg_table stg
WHERE stg.cdate = TRUNC(p_run_date) - 1 and rownum =1;

Report message to a moderator