 Sql Loader Starting Problem [message #440873] |
Wed, 27 January 2010 12:22  |
MR[T]
Messages: 62
Registered: March 2009
|
Member |
|
|
Hello
Its my first time i am using sql loader .
When I try to connect to Sqlloader i use following command .
sqlldr scott/tiger@orcl control= J:\oracle\product\10.2.0\oradata\orcl\CONTROL01.ctl
and it gives me following error message
SQL*Loader-350: Syntax error at line 1.
Illegal combination of non-alphanumeric characters
Regards
MR.T
|
|
|
|
|
|
|
|
| Re: Sql Loader Starting Problem [message #440876 is a reply to message #440875] |
Wed, 27 January 2010 12:51  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
I agree with Mahesh. I think OP does not know that SQL*Loader is and saw the reference to control file, found something in Oracle named "control" and assumed that was the file to use.
It would surely explain the non-text characters.
|
|
|
|
| Re: Sql Loader Starting Problem [message #440877 is a reply to message #440873] |
Wed, 27 January 2010 12:56 |
MR[T]
Messages: 62
Registered: March 2009
|
Member |
|
|
Yes its Oracle control file .
I rode about Sqlloader from here
"http://www.orafaq.com/wiki/Import_Export_FAQ"
Can you please tell me how to create Sqlloader Control file .
Procedure is written on orafaq web .
load data
infile 'c:\data\mydata.csv'
into table emp
fields terminated by "," optionally enclosed by '"'
( empno, empname, sal, deptno )[/size]
But its not given where to write those commands .
|
|
|
|
|
|
|
|
|
|
| Re: Sql Loader Starting Problem [message #440881 is a reply to message #440873] |
Wed, 27 January 2010 13:01 |
MR[T]
Messages: 62
Registered: March 2009
|
Member |
|
|
Can i create Sqlloader Control file from sqlplus ?
and how to create it just write following commands in sqlplus ?
load data
infile 'c:\data\mydata.csv'
into table emp
fields terminated by "," optionally enclosed by '"'
( empno, empname, sal, deptno )
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
