See the following note sent on 4/12/01 - it should assist
John
++++++++++++
Try the following example:
TMD=`date '+%Y/%m/%d'`
TMS=`date '+%Y%m%d%H%M%S'`
sqlplus -s internal <<whisky
set verif off pages 0 echo off feed off term off lines 200
spool $SHELLSRCDIR/dbcontents.$TMS.log
select 'alter database rename file '''||name||''' to '''||name||''';'
from v\$datafile;
column member format a50
select 'alter database rename file '''||member||''' to '''||member||''';'
from
v\$logfile;
spool off
whisky
Regards
Peter Lomax (Oracle DBA)
Expertise Oracle
SG/DSI/SIMBAD/AT&P
OrangeFrance
Bureau:
*: - [EMAIL PROTECTED]
(: (+33) (0)1 55 22 59 13
fax: (+33) (0)1 55 22 39 69
+++++++++++++++++++++++++++++++++++++++
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2002 08:45
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader
Hallo all you gurus,
Anyone who can help me with this:
I have this unix script: In the script I wamt to create a logfile for every day that I run this script so that thel logfile will look like:
2002-02-22laddabsg.log
and when i run the script tomorrow I want it to be:
2002-02-23laddabsg.log
anyone who can help me to complete this unix script
This line executes the sqlloader command and it is this logfile I want to have the runningdate in too.
sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl log=/d31/appl/konto/log/laddabsg.log
(See attached file: loadfast.sh)
Thanks in advance
Roland
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=========================================================
