ORA-39342 ORA-00947 In 12.1.0.2 When Importing With Data Pump Dump File(s) Created In 12.1.0.1

(Doc ID 2231057.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When doing a full metadata Data Pump import in a 12.1.0.2 database from dump file(s) created in a 12.1.0.1 database getting:

Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MARKER
ORA-39342: Internal error - failed to import internal objects tagged with
PSTDY due to ORA-00947: not enough values.

Setting the 947 event in database with:
alter system set events '947 trace name errorstack level 3';
before import shows in DW trace file that failure is occurring in:

----- Error Stack Dump -----
ORA-00947: not enough values
----- Current SQL Statement for this session (sql_id=6qnpvvk4qf9wj) -----
insert into SYSTEM.REDO_LOG select * from SYSTEM.REDO_LOG_TMP

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms