DataPump Import (impdp) Raises ORA-942 When Importing Statistics
(Doc ID 1313200.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Symptoms
You recently upgraded the database from version 10.2 onto 11gR2. Then the DataPump import fails with errors, like:
...
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 1, column 454:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 434:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 489:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 469:
PL/SQL: SQL Statement ignored
Failing sql is:
DECLARE c varchar2(60); nv varchar2(1); df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; s varchar2(60) := 'TEST'; t varchar2(60) := 'BIG_TA
Job "<SCHEMA_NAME>"."<DP_JOB_NAME>" completed with 1 error(s) at 14:38:07
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 1, column 454:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 434:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 489:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 469:
PL/SQL: SQL Statement ignored
Failing sql is:
DECLARE c varchar2(60); nv varchar2(1); df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; s varchar2(60) := 'TEST'; t varchar2(60) := 'BIG_TA
Job "<SCHEMA_NAME>"."<DP_JOB_NAME>" completed with 1 error(s) at 14:38:07
when the statistics are imported.
If you exclude the statistics, then the import works.
DataPump import internally uses the table SYS.IMPDP_STATS. You checked the data dictionary with:
Changes
Upgraded from 10.2.
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 |