error in loading data from .csv file into a table.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error in loading data from .csv file into a table.

Hybrid View

  1. #1
    Join Date
    Oct 2009
    Posts
    30

    error in loading data from .csv file into a table.

    Hi,

    I want to load data from .csv file to a table called dept in my database.

    My .ctl file is as below:
    load data
    infile 'C:\Documents and Settings\prakasn1\Desktop\sqlloader\dept.csv'
    into table dept
    fields terminated by WHITESPACE optionally enclosed by '"'
    trailing nullcols
    (deptid,deptname)


    And my .csv file as below:

    1 sales
    2 marketing
    3 IT
    4 finance

    And the table is created newly and is empty:

    desc dept
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    DEPTID NUMBER(6)
    DEPTNAME VARCHAR2(20)

    When i try to execute it through toad,it throws error as below:

    OPEN TOAD ---> go to DATABASE menu ----->IMPORT ----->SQL*Loader Wizard
    -->Use control file (existing one)
    -->Then give the path of the .ctl file.
    -->Then execute

    ERROR:
    SQL*Loader-500:
    Unable to open file (C:\Documents and Settings\prakasn1\Desktop\sqlloader\dept.csv)
    SQL*Loader-553: file not found
    SQL*Loader-509: System error: The system cannot find the file specified.
    SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

    Even though the path is correct the above error is thrown.Please help. Thanx in advance.

    Regards.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    stop using toad and run it from the command line

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