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

Other related posts:

  • » IMPDP