what kind of OS do you have, if you have unix and kornshell you can make a
..ksh file like:
#!bin/ksh
dayrun='date +%m%d%y'
exp userid=system/manager file=exp.`dayrun`.dmp
or if you are in sqlplus you can do:
sqlplus>host exp userid=system/manager file=exp.`date +%m%d%y`.dmp
In windows you have to figure out how you can display and format the system
date.
-----Original Message-----
From: waheed rashwan [mailto:wahras@xxxxxxxxx]
Sent: Wednesday, January 08, 2003 12:43 PM
To: Oracle
Subject: [oracle] batch file
Hi, i want batch file to make export data from many
schema in the same database and the name of dmp file
is the date for this day.
Thanks for any answers in advance.
=====
With best regards,
Waheed Rashwan
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx
|
Try Searching:
servers, voip, java, networking, microsoft ...
|
|
|
|