dbms_rowid / datapump export / Java script / blob clob extraction using rowids.

We were given this script by a vendor to extract data fast over a encrypted WAN network.

this script extracts different records at different runs and its ususally is all incorrect.

Can someone help ?

#!/bin/ksh

#script_name by_row_id.ksh

#temp add vars so no re-entry during test

STG_CONNECT_STRING=ehc/cokeisit@LC125

stg_ora_home=/u01/app/oracle/product/12.1.0/db

table_owner=ehc

table_name=I\$_CE_BLOB_DECOMP

exp_table_name='I\$_CE_BLOB_DECOMP'

table_name_wo=I_CE_BLOB_DECOMP

num_splits=50

num_runs=8

ksh_dir=/u01/dump

until [[ ${STG_CONNECT_STRING} != "" ]];do read STG_CONNECT_STRING?"Enter stage string (ex. v500/pass@stndby1): "; done