can anybody tell me what's wrong with my SQL loader ctrl file?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: can anybody tell me what's wrong with my SQL loader ctrl file?

  1. #1
    Join Date
    Jan 2001
    Posts
    59

    Here is my control file:
    --------------------------------

    LOAD DATA
    INFILE 'data1.csv'
    REPLACE
    INTO TABLE LOANTEMP
    (
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    LOAN_NUM INTEGER EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    COUPON NUMBER EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    SERVICING NUMBER EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    DELIQUENCY_DAYS INTEGER EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    GROSS_MARGIN NUMBER EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY "\r\n"
    )


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

    Here is the error log file:
    -------------------------

    SQL*Loader: Release 8.1.5.0.0 - Production on Thu Jan 25 18:41:20 2001

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

    SQL*Loader-350: Syntax error at line 6.
    Expecting valid column specification, "," or ")", found keyword external.
    EXTRA_COLUMN FILLER VARCHAR EXTERNAL TERMINATED BY ',' ,
    ^

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



    The EXTRA_COLUMNs are the columns in my .csv datafile which i don't want to upload. why do i get that error message?



  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    try using
    FILLER CHAR instead of
    FILLER VARCHAR EXTERNAL

    d.

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