DataPump Export (EXPDP) Using Transportable Partitions Fails With Error ORA-942

(Doc ID 1507147.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

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:

Cause

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