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 SQLPLU
Try sumthin' like:
EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp
exp / file=${FILENAME} ...
Do a 'man date' to see the different formatting options.
HTH,
Scott Shafer
San Antonio, TX
Jared Still wrote:
>
> -- Forwarded Message --
> Date: Wed, 21 Nov 2001 15:34
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 SQLPLU
-- 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
.dmp
I mean for example if today is 21.11.2001
the exported file whoud have name21112001.dmp or somethi