Home » RDBMS Server » Server Utilities » SQL*LOADER wildcard infile
SQL*LOADER wildcard infile [message #72672] Wed, 27 August 2003 08:17 Go to next message
Karsten Kappe
Messages: 1
Registered: August 2003
Junior Member
Hello

Is ist possible to use wildcards for the infileclause in SQLLOADER controlfile?
I want to do something like this:
load data
infile 'i485*.dat'
The correct name of the infile is i4852040.dat.
Is there a possibility to this?

Thanks
Karsten
Re: SQL*LOADER wildcard infile [message #72673 is a reply to message #72672] Thu, 28 August 2003 09:42 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i beleive,
sqlldr will not support that syntax.
but u can pass the name of data file in command line.
like

----------------------------------------------------------------------

sqlldr userid=scott/tiger control=test.ctl data= i4852040.dat

and control file being

load data
into table test

..
...
other stuff
...
..

----------------------------------------------------------------------

you have to write an OS wrapper script that takes datafile name as input in wildcards..,find the actual filename and pass it to the sqlldr command line!

Previous Topic: Default Value on a column
Next Topic: importing data from Oralce9i to Oracle8i
Goto Forum:
  


Current Time: Sun Jun 30 14:23:10 CDT 2024