-
Trouble using SQL*LOADER
Hi! This is my 1st posting here, hope I dont get disappointed. I have seen others getting a lotta help from here so I also joined....
So the problem : -
I am trying to use SQL*Loader for faster loading...
We have to handle about 3600+ data per hour or so.... 24x7
But the flat file used for uploading is changing so I have used Shell Scripting to create dynamic Loader file.....
Table structure
Name Null? Type
----------------------------------------- -------- ----------
I_RCVD_ID---------------------------------NUMBER(32)
I_PORT_NO--------------------------------NUMBER(6)
S_DEVICE_MFR------------------------VARCHAR2(25)
S_RCVD_DATA-------------------------VARCHAR2(1000) ****
C_READ_STATUS---------------------CHAR(1)
DT_CREATED----------------------------DATE
S_CREATED_BY------------------------VARCHAR2(25)
SRD:- field where the data is being inserted....
CODE: -
LOAD DATA
INFILE '/APP/app/log/net/gprs/PortReader2/load_temp.'
BADFILE '/APP/app/log/net/gprs/PortReader2/backup.bad'
APPEND INTO TABLE DC.TBL_GPRS_RAW_DATA_test
FIELDS TERMINATED BY '@'
(S_RCVD_DATA)
Data which got inserted without problem :- ET200STT:118053,20081021,17:20:30,+21.887963,+83.553099,1,0.003,85.82,55409969,00,1,2488#
(PS:-this is the basic data type to be inserted)
Data Having Problem: -
ET200STT:118031,20081019,09:43:50,+22.865511,
+86.201038,1,0.011,278.92,27428364,00,1,9801ET200STT:118031,20081019,09:53:50,+22.865515,+86.201126, 1,0.161,298.08,27428369,00,1,9802ET200STT:118031,20081019,10:03:50,+22.865535,+86.200993,1,0.111,289 .29,27428378,00,1,9803ET200STT:118031,20081019,10:13:30,+22.865496,+86.201124,1,0.005,271.08,2742837 9,00,1,9804ET200STT:118031,20081019,10:23:30,+22.865503,+86.201086,1,0.007,278.2,27428379,00,1,9805#
SQL*LOADER evoking code
sqlldr Userid=dc/dc@gpstrn control=load.ctl
I would really appreciate your help guys.....
-
but whats the problem, you havent given any errors apart from 'it doesnt work'
-
sorry
well the problem is that the data (longer one) is not getting inserted
The log shows this error
Record 134: Rejected - Error on table DC.TBL_GPRS_RAW_DATA_TEST, column S_RCVD_DATA.
Field in data file exceeds maximum length
where as if I use "Insert" statement for this data then it is getting inserted
-
I have tried to specify the field in the code like this
LOAD DATA
INFILE '/APP/app/log/net/gprs/PortReader2/load_temp.'
BADFILE '/APP/app/log/net/gprs/PortReader2/backup.bad'
APPEND INTO TABLE DC.TBL_GPRS_RAW_DATA_test
FIELDS TERMINATED BY '@'
(S_RCVD_DATA VARCHARC(1,1000))
-
well found the answer ....
