SQL*Loader

[nithin97]

Hi,
i'm using SQL*Loader to load oracle tables.. can i please know whether I can use shell scripting inside a .ctl file 'coz the infile name will be always changing every 15 minutes. So i need to dynamically create the infile name which I can do it in shell scripting. Given below is what i'm trying to do... i dont think this is right.. ur help appreciated...

#!/bin/csh

set filename = xyz_20021001_0000

LOAD DATA

INFILE $filename
INTO TABLE pixel_temp
WHEN (01:05) = 'xyz' TRAILING NULLCOLS
(
TSDatetime POSITION(9:19)
"to_dateTSDatetime,'MMDDYY_HH24MI')"
)

 

[lmorgansky]

Use the shell script outside of the control file to rename your "changing" file names to something standard. Then use this standard name in the control file.

L

 

[nithin97]

THanks lmorgansky.. i'll try ur concept and let u know.. thanks for the help...