ORA-30091: secondary translation table not loaded

  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.