OraFAQ Forum: Server Utilities » sqlldr how and where to execute

Home » RDBMS Server » Server Utilities » sqlldr how and where to execute

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr how and where to execute [message #187937]

Wed, 16 August 2006 07:04

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

Frank
Messages: 7901
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

Littlefoot
Messages: 21823
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>).

Report message to a moderator

Re: sqlldr how and where to execute [message #187947 is a reply to message #187943]

Wed, 16 August 2006 07:39

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

Report message to a moderator

Re: sqlldr how and where to execute [message #187948 is a reply to message #187947]

Wed, 16 August 2006 07:49

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

BEGIN
  WHILE message #187946 <> 'understood'
  LOOP
    READ_AGAIN;
  END LOOP;
END;
/

Report message to a moderator

Re: sqlldr how and where to execute [message #187955 is a reply to message #187937]

Wed, 16 August 2006 08:37

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

Report message to a moderator

Re: sqlldr how and where to execute [message #188022 is a reply to message #187955]

Wed, 16 August 2006 15:50

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: sqlldr how and where to execute [message #188563 is a reply to message #187955]

Sat, 19 August 2006 14:53

Barbara Boehmer
Messages: 9101
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:16:17 CST 2024