on 05-08-2017 3:03 AM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I restarted the database . it worked normally and i could not import continuingly. What should i do?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dear expert,
how should i act in the next step. The indexs ,constraints and other expdp objects had not been processed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ling,
looks like _highthreshold_undoretention is related to bug.
What is the database version and patch level? dba_registry_history?
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.