RE: NT Script

From: Paul Drake <drake_at_psscorp.com>
Date: Mon, 18 Jun 2001 11:12:38 -0700
Message-ID: <F001.0032D871.20010618104619@fatcity.com>

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
kevin_at_dulcian.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
INET: kevin_at_dulcian.com

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: ListGuru_at_fatcity.com (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: drake_at_psscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------