ORA-12841 Error coming while trying to do a parallel insert
443884Sep 30 2005 — edited Oct 3 2005Hi All,
My requirement is to do a parallel insert into a table. This is what I am doing inside the package body EMP_PKG.
EXECUTE IMMEDIATE 'alter session enable parallel dml';
INSERT /*+ PARALLEL (EMP,2,1) */
INTO EMP_DUMMY
SELECT * FROM EMP;
EXECUTE IMMEDIATE 'alter session enable parallel dml';
But this is throwing the following error:
ORA-12841: Cannot alter the session parallel DML state within a transaction
Am I missing some thing here? Please let me know
Thanks in advance :-)