SQLLOADER PROBLEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQLLOADER PROBLEM

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    20
    I am having problems using sqloader

    I want to load a data file into a table and set one column of the table to be a literal that I assign. It is not working Here is what am am doing and the error message can someone help me?

    table desc.:Table name = abc
    COL1 VARCHAR2(5)
    COL2 CHAR(5)
    COL3 DATE



    table as is now:
    COL1 COL2 COL3
    ----- ----- ---------
    JOHN A 19-JAN-01
    leon B 19-JAN-01

    datafile:

    frank
    john
    tim
    al
    tom
    art
    mark
    larry

    control file :
    LOAD DATA
    INFILE 'sqltestload.DAT'
    APPEND
    INTO TABLE abc
    (col1 position(1:5) CHAR,
    col2 "D")


    this is the error that I'm getting in the log file
    Control File: control.ctl
    Data File: sqltestload.DAT
    Bad File: sqltestload.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 ABC, loaded from every logical record.
    Insert option in effect for this table: APPEND

    Column Name Position Len Term Encl Datatype
    ------------------------------ ---------- ----- ---- ---- ---------------------
    COL1 1:5 5 CHARACTER
    COL2 NEXT 1 CHARACTER
    SQL string for column : "D"

    Record 1: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 2: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 3: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 4: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 5: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 6: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 7: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here

    Record 8: Rejected - Error on table ABC, column COL2.
    ORA-00984: column not allowed here


    Table ABC:
    0 Rows successfully loaded.
    8 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: 65532 bytes(5461 rows)
    Space allocated for memory besides bind array: 0 bytes

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

    Run began on Fri Jan 19 13:59:50 2001
    Run ended on Fri Jan 19 13:59:50 2001

    Elapsed time was: 00:00:00.15
    CPU time was: 00:00:00.08




  2. #2
    Join Date
    Jun 2000
    Location
    Conway,AR,USA
    Posts
    29
    Try the following control file

    LOAD DATA
    INFILE 'sqltestload.DAT'
    APPEND
    INTO TABLE abc
    (col1 position(1:5) CHAR,
    col2 CONSTANT "D")


    Soumya
    still learning

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