Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL loader unix script with multiple files

Re: SQL loader unix script with multiple files

From: sybrandb <sybrandb_at_gmail.com>
Date: 2 Jan 2007 02:45:20 -0800
Message-ID: <1167734720.854648.306820@48g2000cwx.googlegroups.com>

On Jan 2, 11:17 am, mnemoni..._at_hotmail.com wrote:
> Hello
> What I have to doe is create for a large set of control en datafile 1
> shellscripts which starts te actual load.
>
> My problem is :
>
> I use variables and check which control files and datafiles are
> present. That goes well.
>
> But what I want is seperate logfiles for each control file so I
> specified a variable for this to take over then name of the
> controlfile, but what happens is that only the log file of the last
> control file is beinig processed.
> here some code:
>
> for LOG_FL in `ls ${DATADIR}/ctl/*.CTL | sed
> 's/\.[^.]*$//'>${DATADIR}/ctl/filelist.txt |cat
> ${DATADIR}/ctl/filelist.txt`
> do
> export LOG_FL
> done
>
> for file in `ls ${DATADIR}/ctl/*.CTL|sort -rn -k 5,5 | awk '{print
> $NF}'`
> do
> sqlldr $SCHEMA/$SCHEMAPWD control=$file log=$LOG_FL
>
> What am I doing wrong here?
>
> regards
>
> Michel

Shouldn't the latter FOR not be included in the former FOR ie
 for LOG_FL in `ls ${DATADIR}/ctl/*.CTL | sed  's/\.[^.]*$//'>${DATADIR}/ctl/filelist.txt |cat  ${DATADIR}/ctl/filelist.txt`
 do
export LOG_FL
for file in `ls ${DATADIR}/ctl/*.CTL|sort -rn -k 5,5 | awk '{print  $NF}'`
do
sqlldr $SCHEMA/$SCHEMAPWD control=$file log=$LOG_FL done
done

Hth

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jan 02 2007 - 04:45:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US