| urgent [message #21204] |
Wed, 17 July 2002 23:20  |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
HI,
If my a.dat file contains the data mentioned below
\servernameh100w141001a.tif
\servernameh100w141001b.tif
\servernameh100w141002c.tif
then in my check.txt file I have the code like this
LOAD DATA INFILE 'a.dat'
INTO TABLE imgsample
(imageid)
then when I type the command at sqlprompt as
$ sqlldr scott/tiger checkt.txt
and then when I check the table it is displaying as three records inserted but when I saw the records
the data is as
imageid
3 records selected.
I want the completed value to be inserted in teh database which is the a.dat file(i.e. is the path)
thanx
|
|
|
|
| Re: urgent [message #21208 is a reply to message #21204] |
Thu, 18 July 2002 01:26  |
Saga
Messages: 51
Registered: April 2002
|
Member |
|
|
Change Your text file to
LOAD DATA INFILE 'a.dat'
INTO TABLE imgsample
(imageid char(100))
and then try. Hope it will work.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
