Kevin.
"Stick to what you are good at."
Are you good in working with sqlplus?
Leverage that skill into making your export .par file dynamic.
Call an sqlplus script that produces (spools) either the export.bat
(and include the file=<path> in the command line)
or the export.par file.
In this manner, you won't have to know every trick in the nt scripting world
- and better yet - its a more cross-platform compatible methodology - for
when you have to support Oracle on more than 1 OS.
You could even execute the rename command via a HOST command in a sqlplus
script.
So you could simply export the database to the same filename each time, but
rename it afterwards.
Or you could compress the dump file(s) to a filename including the date.
Let me know if you need direct examples - but I can't get to it today.
Paul
-----Original Message-----
Sent: Monday, June 18, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L
Hello all,
I know, I know, NT. Anyway, I was wondering if anyone knew how to
append
the system date to a file created through a script. Basically, what I want
to do is have files set up to run exports every night, however, I need to be
able to appened the system date to the file when it is created so I don't
just over write the file that was created the night before. Does anyone
know how to do this, it would be greatly appreciated!!
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
