SQL*Loader
From: Liu Hui Ting <liuht_at_scsxpo.scsnet.scs.com.sg>
Date: 1996/09/05
Message-ID: <322E6830.5B70_at_scsxpo.scsnet.scs.com.sg>#1/1
Date: 1996/09/05
Message-ID: <322E6830.5B70_at_scsxpo.scsnet.scs.com.sg>#1/1
Hi,
I created a binary file which includes 100 integers from 1 to 100. I tried to use SQL*Loader to upload these integers in the data file to oracle table(Which consists of two integer columns). The control file i used is as follow:
LOAD DATA
INFILE 'datafile.dat'
INTO TABLE test_binary
( integer1, POSITION(*) INTEGER,
integer2, POSITION(*) INTEGER
)
But the results were wrong.
Could someone tell what's wrong in the control file(i am very sure the data file was correct)? How to set the POSITION in the control file?
Thanks
--liu
liuht_at_scsxpo.scsnet.scs.com.sg
Received on Thu Sep 05 1996 - 00:00:00 CEST