RE: Sqlloader

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Tue, 22 Jan 2002 02:42:13 -0800
Message-ID: <F001.003F6CB2.20020122022518@fatcity.com>

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:
*: - peter.lomax_at_ftms.fr
(:  (+33) (0)1 55 22 59 13

fax: (+33) (0)1 55 22 39 69

+++++++++++++++++++++++++++++++++++++++

-----Original Message-----
From: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se] 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.

---

Received on Tue Jan 22 2002 - 04:42:13 CST