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.