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].