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

(Doc ID 2231057.1)

Last updated on FEBRUARY 07, 2017

Applies to:

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


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

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


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