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

Thread: sqlldr.exe doesn't exit, why?

  1. #1
    Join Date
    Jan 2001
    Posts
    59

    Lightbulb



    hi experts, I have a question regarding the sqlldr.exe. I don't understand why the sqlldr.exe doesn't exit even after it finishes loading data to the database. Is there anything wrong with my control file or because of something else? Please help! I have been struggling with this for few days.
    Here is my files for the sqlldr. can anyone tell me what the problem is? thanks.


    the command file:
    ---------------------

    sqlldr control=C:\codes\bcp\oracle\testload02.ctl, log=testload.log, bad=testload.bad, data=C:\codes\bcp\oracle\testdata.csv, userid=system/manager@RESEARCH



    the control file.
    -----------------

    LOAD DATA
    INFILE 'testdata.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'
    )


    the datafile:
    --------------

    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



    the log file, "testload.log":
    ----------------------------

    SQL*Loader: Release 8.1.5.0.0 - Production on Thu Feb 1 10:41:31 2001

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

    Control File: C:\codes\bcp\oracle\testload02.ctl
    Data File: C:\codes\bcp\oracle\testdata.csv
    Bad File: testload.bad
    Discard File: none specified

    (Allow all discards)

    Number to load: ALL
    Number to skip: 0
    Errors allowed: 50
    Bind array: 64 rows, maximum of 65536 bytes
    Continuation: none specified
    Path used: Conventional

    Table HGANTEST, loaded from every logical record.
    Insert option in effect for this table: REPLACE

    Column Name Position Len Term Encl Datatype
    ------------------------------ ---------- ----- ---- ---- ---------------------
    LOAN_NUM FIRST * , CHARACTER
    NONE NEXT * , CHARACTER
    (FILLER FIELD)
    CUR_BAL NEXT * , CHARACTER
    INTEREST NEXT * n CHARACTER


    Table HGANTEST:
    5 Rows successfully loaded.
    0 Rows not loaded due to data errors.
    0 Rows not loaded because all WHEN clauses were failed.
    0 Rows not loaded because all fields were null.


    Space allocated for bind array: 65016 bytes(84 rows)
    Space allocated for memory besides bind array: 0 bytes

    Total logical records skipped: 0
    Total logical records read: 5
    Total logical records rejected: 0
    Total logical records discarded: 0

    Run began on Thu Feb 01 10:41:31 2001
    Run ended on Thu Feb 01 10:41:35 2001

    Elapsed time was: 00:00:03.67
    CPU time was: 00:00:00.12




  2. #2
    Join Date
    Jan 2001
    Posts
    59
    addition to my previous post:

    i say it doesn't exit because I had to type 'ctrl-C' to terminate the execution. Here is a screen capture of my command prompt.

    -----------------------------------------
    C:\Inetpub\ftproot>testload

    C:\Inetpub\ftproot>sqlldr control=C:\codes\bcp\oracle\testload02.ctl, log=testload.log, bad=testload
    .bad, data=C:\codes\bcp\oracle\testdata.csv, userid=system/manager@RESEARCH

    SQL*Loader: Release 8.1.5.0.0 - Production on Thu Feb 1 10:54:25 2001

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

    Commit point reached - logical record count 5
    ^CTerminate batch job (Y/N)? y

    C:\Inetpub\ftproot>
    -----------------------------------------------------


  3. #3
    Join Date
    Jan 2001
    Posts
    4
    have you tried usig the silent option

  4. #4
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88
    Hey Thg,

    Place and "exit" statement at the end of the C:\Inetpub\ftproot>testload script.

    Sqlldr is executing and finishing just fine. You need to exit out of the C:\Inetpub\ftproot>testload script


  5. #5
    Join Date
    Aug 2000
    Posts
    462
    The problem is most likely version incompatibility between the OS on the client and the SQLLDR on the client. For example, 8.1.5 SQLLDR won't close on WIN2000.

    In addition, there is a bug in SQLLDR that it sometimes won't close if running on a machine connected to a Novell network.

    Sorry.

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