Database Utilities (MOSC)

MOSC Banner

EXPDP - Hangs and seems to default to CONTENT=ALL

edited Apr 2, 2019 5:03AM in Database Utilities (MOSC) 3 commentsAnswered

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                              "

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center