export scripts automation windows 2003 server

[abinsasi87]

i want some automatic export scripts that run a specific time on daily basis

My platform is windows
My Database is oracle 10g

can any one have to create a batch file for below my workground
username: system/system@mir as sysdba

connected

enter array feth buffer size: 4096>
export file: expdat.dmp>g:\backup\26-04-13
<1>e<ntire database>, <2>u<users>,<3>T<ables>:<2>u >
export grants yes
export table data yes
compress extents yes
export done in....
user to be exported:<return to quit> > mir
user to be exported:<return to quit> > accounts
user to be exported:<return to quit> > purchase
user to be exported:<return to quit> > hrms
user to be exported:<return to quit> > crm
user to be exported:<return to quit> > crs
quit

please help

 

[yelworcm]

At a command line, type exp help=Y, and you should get all of the parameters required for an export. You will likely need to leave the system user's password in clear text, so be careful where you leave this batch file. Once you have the command rounded out, you can schedule it in Scheduled Events on Windows.

 

[LKBrwnDBA]

Here are some links with example scripts:

http://www.orafaq.com/scripts/win/dbexp.txt

http://www.praetoriate.com/t_advanced_oracle_scripts_windows.htm

http://www.dba-oracle.com/t_scripts_windows_export.htm

Good luck!



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb