DataPump Export (EXPDP) Using Transportable Partitions Fails With Error ORA-942
(Doc ID 1507147.1)
Last updated on JANUARY 30, 2020
Applies to: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
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
When trying to export individual partitions or subpartitions using DataPump with transportable table method, the following errors are raised:
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [INDEX:"MV"."I_PTAB"]
ORA-942: table or view does not exist
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPW$WORKER", line 7839
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 12:42:50
The command line used for export is:
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