IMPDP

Has anyone encountered the following error using impdp using parallelism; this is an excerpt from a 5 GB trace file that impdp generated in the bdump directory.

***Got internal error Exception caught in pfrrun() while running PLSQL***
***Got ORA-21780 while running PLSQL***
PACKAGE BODY SYS.KUPM$MCP: It generated the trace file during the stats import phase of impdp
(after completing metadata creation of tables, data import, metadata
creation of rest of the objects, index creation in that order). I googled this error and looked in metalink, but found nothing. The surprising part is if I run this without the parallel clause and not in a shell script, it runs fine. My shell script has nothing but a couple of impdp statements like below.

I am importing a schema from another schema. Following was the syntax used; directory was created inside the database and read/write permissions were granted correctly.

impdp / REMAP_SCHEMA=OLD_OWNER:NEW_OWNER REMAP_TABLESPACE=OLD_TS:NEW_TS parallel=8 DIRECTORY=expdir DUMPFILE=jpayexppump.dmp LOGFILE=jpay_own06_impdp.log

Env: db 10.2.0.2 + DST on HP-UX 11.11
Impdp 10.2.0.2.

Thanks in advance for your inputs.

Amit Verma
ES-DAS Database Administrator
(425) 424-7890

--
http://www.freelists.org/webpage/oracle-l