datapump question
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
- Date: Wed, 22 Oct 2008 15:29:12 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
