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

Thread: invoke sql loader in window NT/2000?

  1. #1
    Join Date
    Jan 2001
    Posts
    59


    my data.csv
    -------------

    1, 7.6, 23232.24, 9.6
    2, 8.3, 34353.53, 8.3
    3, 6.7, 55353.53, 8.6
    4, 9.4, 63472.53, 9.8
    5, 8.2, 44443.53, 8.1



    my load.ctl
    -------------

    LOAD DATA
    INFILE 'data.csv'
    REPLACE
    INTO TABLE hgantest
    (loan_num INTEGER EXTERNAL TERMINATED BY ',',
    none FILLER DECIMAL EXTERNAL TERMINATED BY ',',
    cur_bal DECIMAL EXTERNAL TERMINATED BY ',',
    interest DECIMAL EXTERNAL TERMINATED BY '\n'
    )


    my batch command file:
    ----------------------------

    SQLLDR CONTROL="C:\codes\bcp\oracle\load.ctl", LOG=bar.log, BAD=baz.bad, DATA="C:\codes\bcp\oracle\data.csv"
    pause





    Error messages::::::::::
    ----------------------------------------------------

    C:\codes\bcp\oracle>SQLLDR CONTROL="C:\codes\bcp\oracle\load.ctl", LOG=bar.log,
    BAD=baz.bad, DATA="C:\codes\bcp\oracle\data.csv"
    Username:system
    Password:

    SQL*Loader: Release 8.1.5.0.0 - Production on Wed Jan 24 16:17:05 2001

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
    ORA-12560: TNS:protocol adapter error

    C:\codes\bcp\oracle>pause
    Press any key to continue . . .

    ---------------------------------------------------------------


    Can anyone tell me what's wrong with my control file?
    does it have something to do with my ODBC setting? Thanks.


  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Try Username:system@xyz where xyz is service name for the database you are loading.



    [Edited by sreddy on 01-24-2001 at 05:35 PM]

  3. #3
    Join Date
    Jan 2001
    Posts
    59

    thanks


    thank you. it works.

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