DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlloader

  1. #1
    Join Date
    Sep 2000
    Posts
    2

    Thumbs up


    hi
    i need a help on sqloader. i hv .dat file which consist the fields
    like as follows

    inv.dat
    -------

    "abc",92,3,"vish,"rad","bad",25

    "xyz",92,2,"lath","path",36

    "pqr",93,4,"car","van","jeep,"truck",45

    depending on the third column the values will be changing and it will be
    loading into the oracle table as follows but we are not considering the
    third column in the dat file.

    name status psn1 psn2 psn3 psn4 psn5 inv
    ---- ------ ---- ---- ----- ----- ----- -----
    abc 92 vish rad bad null null 25
    xyz 92 lath path null null null 36
    pqr 92 car van jeep truck null 45


    Actually the third column in DAT file is not the column of the oracle table .
    it indicating the no of values are going to store in the psn1 psn2 ...
    let say, the third column is 2 and the data will be loaded in psn1 and psn2
    and remaining psn3,psn4 and psn5 shud load as NULLs.

    i would appreciate if any body has a solution for the above problem,how
    we can load the data (using sqlloader) from DAT file to oracle table the
    above dat file to table where the psn1 psn2 values are not fixed.
    kindlyprovide me the solution as soon as possible and let me know the
    possible ways of the above said problem.


    thanks in advance

    swetha

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi swetha

    we can do this with the SQL*Loader. But it could be the easy if you would wirte a PRO*C .

    If you have any questions, feel free to contact.

    Thanks.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi swetha

    my email id- chandra_2000_us@yahoo.com


    [Edited by Chandra on 11-14-2000 at 09:13 AM]
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  4. #4
    Join Date
    Sep 2000
    Posts
    2

    sqloader

    hi Mr.chandra...

    thankx for the reply. how can i accomplish the same thing using sqlloader.
    if u find time kindly give the solution also with all possible ways


    swetha

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