cancel
Showing results for 
Search instead for 
Did you mean: 

brtools impdp terminate

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

dear expert,

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

Former Member
0 Kudos

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

JamesZ
Advisor
Advisor
0 Kudos

Hi Ling,

looks like _highthreshold_undoretention is related to bug.

What is the database version and patch level? dba_registry_history?


Best regards,
James