Basic LOB files export using datapump

 How to export Basic LOB files export in parallel.

It is known limitation that LOBs of type basic files cannot be exported in parallel. 

Below is the syntax for executing concurrently in multiple threads for LOB Segments with multiple dumps. eg : 16 threads in background

Generate script as below for each and run in background from server.

expdp <username@<TNS> 

tables=<table name> 

dumpfile=Directory_name:dumpfile%U.dmp

logfile = Directory_name:logile_name1.log 

query=schema.tablename:' " where mod(dbms_rowid.rowid_block_number(rowid),16)=0" ' &

query=schema.tablename:' " where mod(dbms_rowid.rowid_block_number(rowid),16)=1" ' &

...

....

query=schema.tablename:' " where mod(dbms_rowid.rowid_block_number(rowid),16)=15" ' &