RE: batch file

"David, Romeo B. (Govt)" <[email protected]> Wed, 8 Jan 2003 14:20:14 -0500
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-825773-2003.01.08-19.21.29--gcdod-oracle#[email protected]>
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:[email protected]]
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 [email protected].