ORA-39094: Parallel execution not supported in this database edition

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

This morning i was trying out a demo of DBMS_DATAPUMP found at psoug.org and initially i wasn't getting the expected file dump, so i slightly modified the procedure in order to understand where it was stopping. The problem with this nice demo is in that it must have been written for Oracle 10g Enterprise Edition (i was testing this on a 10gR2 SE) because, after a couple of misses, i eventually isolated the failing statement:

DBMS_DATAPUMP.SET_PARALLEL(dph, 2);

After surrounding this statement with an error trapping block:

 ...
 -- set parallelism
 begin
   dbms_datapump.set_parallel(dph, 2);
 exception
 when xcp_39002 then null;
 end;
 ...

i could successfully complete the demo and here is what i found at beginning of the DBMS_OUTPUT message trail:

ORA-39002: invalid operation
ORA-39094: Parallel execution not supported in this database edition.

This is expected behavior as per the official documentation.

See message translations for ORA-39094 and search additional resources.