ORA-31693: Table data object "DEV1"."TABLE_CUST" failed to load/unload and is being skipped due to error:
ORA-30091: secondary translation table not loaded
Data Pump Import Reports ORA-31693,ORA-30091: Secondary Translation Table Not Loaded (Doc ID 2736570.1)
SYMPTOMS:
Performing a Data Pump Import the following errors occur:
ORA-31693: Table data object "USER"."TABLE" failed to load/unload and is being skipped due to error:
ORA-30091: secondary translation table not loaded
CAUSE:
The source database has a newer timezone version than the target database:
Target database timezone version:
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_26.dat 26 0
Source database timezone version :-
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_28.dat 28 0
SOLUTION :-
Install the newer Timezone Version on the Target Database.
SQL> shut
immediate
SQL> startup
upgrade
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size
2926472 bytes
Variable Size
889194616 bytes
Database Buffers
1241513984 bytes
Redo Buffers
13848576 bytes
Database mounted.
Database opened.
SQL> EXEC
DBMS_DST.BEGIN_UPGRADE (28);
PL/SQL procedure successfully completed.
SQL> shut
immediate
SQL> startup
SQL> SELECT
version FROM v$timezone_file;
VERSION
----------
28
Retest issue.
