Home » RDBMS Server » Server Utilities » Sql Loader Starting Problem (10g)
icon4.gif  Sql Loader Starting Problem [message #440873] Wed, 27 January 2010 12:22 Go to next message
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 #440874 is a reply to message #440873] Wed, 27 January 2010 12:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post your controlfile.
Meanwhile,
Is this your Sqlldr controlfile?
The location and naming of the file scares me. Looks like Oracle database controlfile.
Re: Sql Loader Starting Problem [message #440875 is a reply to message #440873] Wed, 27 January 2010 12:34 Go to previous messageGo to next message
BlackSwan
Messages: 24917
Registered: January 2009
Senior Member
What happens if you first
CD J:\oracle\product\10.2.0\oradata\orcl\
sqlldr scott/tiger@orcl control=CONTROL01.ctl


Re: Sql Loader Starting Problem [message #440876 is a reply to message #440875] Wed, 27 January 2010 12:51 Go to previous messageGo to next message
joy_division
Messages: 4618
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 Go to previous messageGo to next message
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 #440878 is a reply to message #440877] Wed, 27 January 2010 12:58 Go to previous messageGo to next message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But its not given where to write those commands .

Anywhere you want, with any name you want, but try to not overwrite a database file.

Regards
Michel
Re: Sql Loader Starting Problem [message #440879 is a reply to message #440877] Wed, 27 January 2010 12:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

Your quote from OraFAQ is the controlfile.
The thingies written inside are the sqlldr commands.
Re: Sql Loader Starting Problem [message #440880 is a reply to message #440873] Wed, 27 January 2010 12:59 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
-BlackSwan

It gives me following error message .


SQL*Loader-500: Unable to open file (CONTROL01.ctt]
Re: Sql Loader Starting Problem [message #440881 is a reply to message #440873] Wed, 27 January 2010 13:01 Go to previous messageGo to next message
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 )
Re: Sql Loader Starting Problem [message #440882 is a reply to message #440881] Wed, 27 January 2010 13:08 Go to previous messageGo to next message
Michel Cadot
Messages: 63820
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just use notepad.

Regards
Michel
Re: Sql Loader Starting Problem [message #440888 is a reply to message #440873] Wed, 27 January 2010 13:56 Go to previous messageGo to next message
MR[T]
Messages: 62
Registered: March 2009
Member
Thanks Alot Every One Smile
Its Working Smile

One Last Question .
Where does it save Export Files ?



Re: Sql Loader Starting Problem [message #440890 is a reply to message #440888] Wed, 27 January 2010 14:46 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You should seriously consider reading Utilities manual.

What "export files"? SQL*Loader does not export anything.
Re: Sql Loader Starting Problem [message #440922 is a reply to message #440890] Wed, 27 January 2010 23:15 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Just to add some more By giving the link....
Utilities manual

sriram Smile
Previous Topic: Where to find scheduled jobs (dbms_scheduler)
Next Topic: Invalid Objects after done import
Goto Forum:
  


Current Time: Sat Oct 01 16:12:24 CDT 2016

Total time taken to generate the page: 0.08475 seconds