EXPDP - Hangs and seems to default to CONTENT=ALL
The gist of the schema design is a 3-byte string starting in position 10 of the table name identifies the business unit. . .
Contents of the parameter file:
JOB_NAME=COMP559_DATA_EXPORT
SCHEMAS=<schema>
PARALLEL=4
LOGTIME=ALL
METRICS=Y
CONTENT=DATA_ONLY <<<<<<<<<<<< job is SUPPOSED export only the data
DUMPFILE=DTPMP_SBX:COMP559_DATA_%U.dmp
REUSE_DUMPFILES=Y
LOGFILE=DTPMP_LOGS:COMP559_DATA_EXPORT.log
INCLUDE=TABLE:"IN(SELECT table_name from SYS.DBA_TABLES where owner = '<schema>' and substr(table_name,10,3) = '559')"
Script used to invoke "expdp":
echo " "
echo "======================================================================="
echo " "
echo " S A N D B O X "