Skip to Content
0

brtools impdp terminate

May 08, 2017 at 02:03 AM

84

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

James Zhang
May 08, 2017 at 07:40 AM
0

Hi Ling,

looks like _highthreshold_undoretention is related to bug.

What is the database version and patch level? dba_registry_history?


Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 09, 2017 at 01:06 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 09, 2017 at 01:09 AM
0

dear expert,

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 09, 2017 at 01:13 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 09, 2017 at 11:41 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded