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 MAY 26, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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
Changes
Data Pump import in a 12.1.0.2 database from dump file(s) created in a 12.1.0.1 database.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |