Labels

Friday, August 2, 2013

expdp pipe small size

#!/bin/ksh

ORACLE_SID=
ORACLE_HOME=
ORACLE_BASE=/u01/app/orascp
LOG_FILE=schema_export.log
export ORACLE_SID ORACLE_HOME ORACLE_BASE

expdp \'/ as sysdba\' DIRECTORY=DMPDIR SCHEMAS= DUMPFILE=_DUMP_%U.dmp LOGFILE=$LOG_FILE EXCLUDE=STATISTICS PARALLEL=2 FILESIZE=10G JOB_NAME=_EXPORT_NEW compression=all
echo "export datapump schema level completed at $(date)" >> /u05/expdp_backup/$LOG_FILE
cd /u05/expdp_backup
ls -ltr>>/u05/expdp_backup/$LOG_FILE
cat /u05/expdp_backup/$LOG_FILE| mailx -s "export of schema " subudba@gmail.com
exit
EOF

1 comment:

  1. Nice to know that you started blogging again! Keep it Up...

    ReplyDelete