-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|