Export schema both metadata and data


expdp_schema.sh
#!/usr/bin/ksh
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'
expdp system directory=DATA_PUMP_DIR schemas=scott logfile= scott_expdp_${dt}.log
dumpfile=scott_${dt}.dmp
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: