Database Utilities (MOSC)

MOSC Banner

need help in modification with oracle export script

edited Sep 26, 2011 2:26AM in Database Utilities (MOSC) 4 commentsAnswered ✓
Hi,

Windows 2003, Oracle 8.1.7

I am trying to write a script for oracle export of whole database which i have to schedule every week. My script is as follows:

# export_full.bat 

exp userid=system/manager

file= e:\exportsorcl_%date:~4,2%-%date:~7,2%-%date:~12,2%.dmp

log=e:\exportsmysid_%date:~4,2%-%date:~7,2%-%date:~12,2%.log

full=y

consistent=y

--------------------------------  ********  -------------------------------

I would like to name each dump file by the date on which it is exported. When i try the above script, it creates a simple dump file like expdat.dmp and no logfile is generated.

can someone please help me in correcting this script.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center