DataPump Export (EXPDP) Does Not Export Rows In Table Partitions When Event 10195 Is Enabled

(Doc ID 1060028.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 10.2 and later ]
Information in this document applies to any platform.


When using DataPump Export, some tables and table partitions are not exported although they have several rows. The dump file estimation file is 0 Kb when exporting only the table. No error is raised.

The tables are correctly exported with simple exp.


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