Thursday, July 17, 2014

AUTOMATIC DATE while doing EXPDP----IMPDP



'date "+%Y%m%d%H%M%S"'

Use dumpfile=Uday_'date "+%Y%m%d%H%M%S"'.dmp


expdp system/********* full=Y directory=DATA_PUMP_DIR dumpfile=Uday_'date "+%Y%m%d%H%M%S"'.dmp logfile=Uday_'date "+%Y%m%d%H%M%S"'.log


impdp system/********* full=Y directory=DATA_PUMP_DIR dumpfile=Uday_'date "+%Y%m%d%H%M%S"'.dmp logfile=Uday_'date "+%Y%m%d%H%M%S"'.log



 

No comments:

Post a Comment