Skip to Content
avatar image
Former Member

brtools impdp terminate

dear expert,

When i impdp a big talbe bsis's expdpfile with brtools and action option was 'replace', the table data was succesfully imported. But when next process the index~0. the error was occurred . The oracle alert log was that " _highthreshold_undoretention is set lower than low threshold retention. Rectify this for high threshold retention to be honored". In this situation, what shoud i do.? How could i continue the impdp job? Please give me a guide. Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 08, 2017 at 07:40 AM

    Hi Ling,

    looks like _highthreshold_undoretention is related to bug.

    What is the database version and patch level? dba_registry_history?


    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2017 at 01:06 AM

    ACTION_TIME
    ---------------------------------------------------------------------------
    ACTION NAMESPACE
    ------------------------------ ------------------------------
    VERSION ID BUNDLE_SERIES
    ------------------------------ ---------- ------------------------------
    COMMENTS
    --------------------------------------------------------------------------------
    13-MAR-11 01.21.47.117566 PM
    APPLY SERVER
    10.2.0.4 4 PSU
    PSU 10.2.0.4.4


    ACTION_TIME
    ---------------------------------------------------------------------------
    ACTION NAMESPACE
    ------------------------------ ------------------------------
    VERSION ID BUNDLE_SERIES
    ------------------------------ ---------- ------------------------------
    COMMENTS
    --------------------------------------------------------------------------------
    13-MAR-11 01.21.49.835755 PM
    APPLY SERVER
    10.2.0.4 3 OPSU
    PSU 10.2.0.4.7


    ACTION_TIME
    ---------------------------------------------------------------------------
    ACTION NAMESPACE
    ------------------------------ ------------------------------
    VERSION ID BUNDLE_SERIES
    ------------------------------ ---------- ------------------------------
    COMMENTS
    --------------------------------------------------------------------------------
    13-MAR-11 01.30.18.338917 PM
    APPLY SERVER
    10.2.0.4 201102 SBP
    SBP 10.2.0.4.7 201102 containing CPUJan2011


    ACTION_TIME
    ---------------------------------------------------------------------------
    ACTION NAMESPACE
    ------------------------------ ------------------------------
    VERSION ID BUNDLE_SERIES
    ------------------------------ ---------- ------------------------------
    COMMENTS
    --------------------------------------------------------------------------------
    13-MAR-11 01.36.17.910108 PM
    APPLY SERVER
    10.2.0.4 4 PSU
    PSU 10.2.0.4.4

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2017 at 01:09 AM

    dear expert,

    how should i act in the next step. The indexs ,constraints and other expdp objects had not been processed.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2017 at 01:13 AM

    I restarted the database . it worked normally and i could not import continuingly. What should i do?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2017 at 11:41 PM

    Hi,

    What is the value of undo_retention in your database ?

    Database is running on unsupported version and not sure which version of BRTools is running on your system!

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded