Export tables using parfile only metadata having exclude parameter


expdp_parfile.par
directory=data_pump_dir
content=metadata_only
tables=scott.emp, scott.dept
exclude=statistics
logfile=ocmdb_scott_tables_expdp_test.log
dumpfile=ocmdb_scott_teable_test.dmp


expdp_using_parfile.sh
#!/bin/bash
set -x
dt=‘date=%y%m%d%H%M‘
export ORACLE_SID=anardb;
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1;
echo 'date'
echo $ORACLE_HOME
expdp system PARFILE=expdp_parfile.par
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: