Monday, June 1, 2015

Export Script In Oracle DB "System" User

This is working Properly.


#!/bin/sh
STARTTIME=`date`
export ORACLE_SID=ORCL243
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
DATEFORMAT=`date +%Y%m%d`
export PATH=$PATH:$ORACLE_HOME/bin
DATEFORMAT=`date +%Y%m%d`
STARTTIME=`date`
exp userid=system/oracle@ORCL243 file=/u01/app/backup/`echo $ORACLE_SID`_`echo $DATEFORMAT`.dmp log=/u01/app/backup/`echo $ORACLE_SID`_`echo $DATEFORMAT`.log full=y compress=n statistics=none
ENDTIME=`date`

No comments:

Post a Comment