Re: Fwd: A problem

Hi !

May be this will help you (I hope).
This solution is for Windows (X) but
with some work it will do also in UNIX.

A procedure called BackupOSC is created by the DBA in his schema.
A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls SQLPLUSW to run the above procedure. The outcome is a batch command file called exp_OSC.cmd wich is invoked by the firts batch file to perform the real export.

The "secret" is to use the SQL to create the second file since DOS hasn't the ability to handle strings.

The example files are within an attached zip file. The file exp_Ora.ftp is a parameter file for to FTP the DMP files to other machine.
If you find some strange words in the files, they are Portuguese.

Hope it helps.
Dias Costa

P.S.: My apologies for I have sent the files unziped.

Jared Still wrote:
>
> ---------- Forwarded Message ----------
> Date: Wed, 21 Nov 2001 15:34:27 +0100
>
> I have created a job to export a user shema
> How can I tell Oracle each time it make the export to use lets say
> <name><date>.dmp
> I mean for example if today is 21.11.2001
> the exported file whoud have name21112001.dmp or something like this...
>
> -------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.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: Dias Costa
  INET: dcosta_at_lnec.pt

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