DataPump Export (EXPDP) Using Transportable Partitions Fails With Error ORA-942
(Doc ID 1507147.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.1 to 11.2]
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