Database Administration (MOSC)

MOSC Banner

Expdp completing without an error but for many rows it is exporting 0 rows 0 kb

Hi Everyone,

My Schema Expdp is completing with no error but for many tables and table partitions it is showing " 0 KB    0 rows"

Sample from logfile:

. . exported "ABC"."XYZ":"SYS_P24520"."SYS_SUBP24519"   0 KB    0 rows

. . exported "ABC"."XYZ":"SYS_P25385"."SYS_SUBP25375"   0 KB    0 rows

. . exported "ABC"."XYZ":"SYS_P25385"."SYS_SUBP25381"   0 KB    0 rows

. . exported "ABC"."XYZ":"SYS_P25385"."SYS_SUBP25382"   0 KB    0 rows


One of solution which I got is ,"Event 10195 is enabled in the database with:

event = 10195 trace name context forever, level 1 , and we need to disable this event."

To check if any event like this is enabled I got one script on google as below.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center