Home » RDBMS Server » Server Utilities » sqlldr how and where to execute
sqlldr how and where to execute [message #187937] Wed, 16 August 2006 07:04 Go to next message
vikas_miraj2003
Messages: 13
Registered: July 2006
Location: INDIA
Junior Member
hello,sir
Below given is sqlldr executed by me in sql plus but
it gives errors pl help me how to use this n where to use
iam using oracle 8i
SQLLDR VIKAS/VIKAS2003@LMSERVER control=LOADER.ctl LOG=MyData.log
data=TEST_mgr.csv

load data
infile 'E:\vikas\TEST_MGR\TEST_mgr.CSV'
into table emp_V
fields terminated by "," optionally enclosed by '"'
( empno, empname,empadd, salary)


thanking you

vikas

[Updated on: Wed, 16 August 2006 07:35]

Report message to a moderator

Re: sqlldr how and where to execute [message #187943 is a reply to message #187937] Wed, 16 August 2006 07:25 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you want an answer to your question:
- do not post in the Test-forum
- tell us WHICH errors you get.


[Edit: Moved to ServerUtilities]

[Updated on: Wed, 16 August 2006 07:26]

Report message to a moderator

Re: sqlldr how and where to execute [message #187946 is a reply to message #187943] Wed, 16 August 2006 07:37 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL*Loader is NOT to be run at the SQL*Plus prompt, but your operating system prompt (in Microsoft Windows, that would be "Command prompt", found at Start -> Run -> CMD <press Return>).
Re: sqlldr how and where to execute [message #187947 is a reply to message #187943] Wed, 16 August 2006 07:39 Go to previous messageGo to next message
vikas_miraj2003
Messages: 13
Registered: July 2006
Location: INDIA
Junior Member
hello
sir,
I have an error ora 900 invalid sql statment
thanks for reply but please guide me

what is the procedure to use sqlldr
in sql plus it is giving error
Re: sqlldr how and where to execute [message #187948 is a reply to message #187947] Wed, 16 August 2006 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
BEGIN
  WHILE message #187946 <> 'understood'
  LOOP
    READ_AGAIN;
  END LOOP;
END;
/
Re: sqlldr how and where to execute [message #187955 is a reply to message #187937] Wed, 16 August 2006 08:37 Go to previous messageGo to next message
vikas_miraj2003
Messages: 13
Registered: July 2006
Location: INDIA
Junior Member
hello
sir,
thank's a lot for reply
it's giving error like syntax error at line 3
data is not a valid internal or external command
when executed

SQLLDR VIKAS/VIKAS2003@LMSERVER control=LOAD.ctl LOG=MyData.log
data=TEST_mgr.csv

and error like
load is not an recognized..i/o command
likewise
pl help


thank's a lot

vikas

Re: sqlldr how and where to execute [message #188022 is a reply to message #187955] Wed, 16 August 2006 15:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you should read the SQL*Loader manual; if "data=test_mgr.csv" is a part of the SQL*Loader statement, it shouldn't be there - input file is declared in the control (.ctl) file.

Errors you receive shouldn't be written as "likewise" because nobody here knows what your were doing if you don't exactly tell us. Now, my guess would be that "SQLLDR is not recognized as an internal or external command, operable program or batch file". If so, it seems that SQL*Loader isn't installed on your computer (or it has a different name than the one you specified).
Re: sqlldr how and where to execute [message #188563 is a reply to message #187955] Sat, 19 August 2006 14:53 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
If you are running it from the SQL> prompt in SQL*Plus, then put the HOST command in front of it, like:

SQL> HOST SQLLDR VIKAS/VIKAS2003@LMSERVER control=LOAD.ctl LOG=MyData.log data=TEST_mgr.csv

If you are running it from the operating system command prompt, then you either need to have it all on one line or use a hyphen to indicate that you are continuing on the next line, like:

C:\> SQLLDR VIKAS/VIKAS2003@LMSERVER control=LOAD.ctl -
C:\> LOG=MyData.log -
C:\> data=TEST_mgr.csv

From the mangled abbreviation of the error message that you provided, it appears that you are running it from the operating system without the hyphens for continution and that your third line starts with data and it is saying that it is not a recognized command because it does not recognize that it is part of the command on the previous line without the continuation character.

You can specify the data file in either the command line or the control file, but it should not be in both.


[Updated on: Sat, 19 August 2006 14:54]

Report message to a moderator

Previous Topic: Loading default value when exists null or blanks SQL Loader
Next Topic: SQL optimizer
Goto Forum:
  


Current Time: Sat Dec 10 14:45:22 CST 2016

Total time taken to generate the page: 0.07167 seconds