oracle11g - Oracle Data Pump Export (expdp) locks table (or something similar) -

i must export data partitioned table global index must online time, having troubles in doing that. data export using data pump export - expdp , exporting 1 partition. oldest one, not active one.

my expdp command exports correct data , looks this:

expdp user/pass@sid directory=exp_dir  dumpfile=part23.dmp tables=schema_name.table_name:table_partition_23` 

application uses database has connection timeout of 10 seconds. parameter can't changed. if insert queries not finished within 10 seconds, data written backup file.

my problem that, during export process lasts few minutes, data ends in backup file, , not in database. want know why, , avoid it.

partitions organized weekly, , keeping 4 partitions active (last 4 weeks). every partition 3 gb.

i using oracle 11.2

are licensed use awr? if so, have awr report snapshot when timeouts occurred?

oracle readers don't block writers , there no reason export process lock impact new inserts.

is single insert operation has timeout of 10 seconds (i.e. inserting large number of rows in single insert statement)? or batch of individual inserts such of inserts can succeed in 10 second window , can fail? "some data ends in backup file" i'm not sure of these scenarios more accurate.

during normal operations, how close 10 second time-out?

is possible system i/o bound , doing export increases load on i/o system causing operations slower? if you've got i/o bottleneck , add export process has read 3 gb partition , write data disk (presumably on database server), cause general slowdown. if you're reasonably close 10 second time-out already, push on edge.