Trouble using SQL*LOADER
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Trouble using SQL*LOADER

  1. #1
    Join Date
    Oct 2008
    Posts
    5

    Red face 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.....

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    but whats the problem, you havent given any errors apart from 'it doesnt work'

  3. #3
    Join Date
    Oct 2008
    Posts
    5

    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
    Last edited by rishab; 10-24-2008 at 04:54 AM.

  4. #4
    Join Date
    Oct 2008
    Posts
    5
    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))
    Last edited by rishab; 10-24-2008 at 04:54 AM.

  5. #5
    Join Date
    Oct 2008
    Posts
    5
    well found the answer ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width