datapump question

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Wed, 22 Oct 2008 15:29:12 -0400
Message-ID: <48FF7F08.70409@tufts.edu>

Hi List members,

I had problem with expdp, the parfile I used as below; this is peoplesoft HR system, it generate a lot of errors. Before I open a SR with oracle, just wondering if anyone have the same issue?

Thanks,

Joan

userid=/
DIRECTORY=EXPDP_DIR
dumpfile=exp_pipe.dmp
schemas=sysadm

---

ORA-31693: Table data object "SYSADM"."PS_TAX_BALANCE" failed to load/unload and is being skipped due to error:

ORA-00001: unique constraint (C0RA1E.SYS_C00197887) violated
ORA-06512: at "SYS.KUPF$FILE", line 2580
ORA-06512: at line 1

ORA-31693: Table data object "SYSADM"."PS_TAX_BALANCE" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-01000: maximum open cursors exceeded
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3806
ORA-06512: at "SYS.DBMS_METADATA", line 4502
ORA-06512: at line 1

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

Received on Wed Oct 22 2008 - 14:29:12 CDT