FAQ
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

Search Discussions

  • Martin Berger at Oct 23, 2008 at 5:15 am
    Hi Joan,

    have you checked if the exp session really hit the maximum open cursors?
    Can you increase them and try again?

    best regards,
    Martin

    --
    Martin Berger
    http://berx.at/

    Am 22.10.2008 um 21:29 schrieb Joan Hsieh:
    ORA-01000: maximum open cursors exceeded
    --
    http://www.freelists.org/webpage/oracle-l

    application/pkcs7-signature attachment: smime.p7s
  • Steve montgomerie at Oct 26, 2008 at 3:55 am
    I'd agree to check max cursors. I've had lots of experience as of late
    datapumping sysadm around in PS if you want to swap stories. Particularly in
    regards to performance.

    steve
    On Thu, Oct 23, 2008 at 1:15 AM, Martin Berger wrote:

    Hi Joan,

    have you checked if the exp session really hit the maximum open cursors?
    Can you increase them and try again?

    best regards,
    Martin

    --
    Martin Berger
    http://berx.at/

    Am 22.10.2008 um 21:29 schrieb Joan Hsieh:

    ORA-01000: maximum open cursors exceeded
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 22, '08 at 7:29p
activeOct 26, '08 at 3:55a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase