Hi,

You can do it with a dos-batch and Windows task-scheduler.

1. DOS Script (EXPORT_DB.BAT)

REM setting variables year.month.day
call today.bat
REM Set Variable export_file_name to year.month.day
set export_file_name=export%year%_%month%_%day%.dmp
set log_file_name=log%year%_%month%_%day%.log
REM Export Database
exp userid=u/[Email Address Removed] file=%export_file_name% log=%log_file_name%

2. DOS Script (TODAY.BAT)
rem ************************************************
rem echo off
IF NOT '%1'=='' GOTO SetEnvVars
for /F "delims=/ tokens=1-4" %%i in ('date /t') do today.BAT %%i %%j %%k
%%l
GOTO Done
:SetEnvVars
:: set DayOfWeek=%1
set Month=%2
set Day=%3
set Year=%4
:Done
rem ************************************************

TODAY.BAT and EXPORT_DB.BAT have to in same directory.

HTH

Volker Schoen



-----Ursprüngliche Nachricht-----
Von: VGaddipati [mailto:oracledba-ezmlmshield-x24587909.[Email address protected]
Gesendet: Freitag, 28. Oktober 2005 10:23
An: LazyDBA Discussion
Betreff: Export Script !!! Urgent !!!!!!!!!!!

Hi Folks,

Does Someone have a script to perform export and schedule it to run for a specific time on windows machine.

The dump file format should be <filename.dmp_dd_mm_yy> .

thanks in advance


Kind Regards,
Venugopal R.
Technical Architect (Database Services).



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page