OraFAQ Forum: Server Utilities » using sqlloader to loading xml file

Home » RDBMS Server » Server Utilities » using sqlloader to loading xml file

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

using sqlloader to loading xml file [message #74571]

Sun, 09 January 2005 00:48

Amal
Messages: 9
Registered: January 2005

Junior Member

Hi...
Hope u can help me with this problem .....
am trying to load xml document into oracle table,,, by using Sql Loader
u know am in a middle of project and i have to finish this step to continue..

see, i already generated XML file and i bulit a table in oracle with XMLType column:

create table clob_xml(xmldoc SYS.xmltype);

and through notepad i write this code and save it by name work.ctl
------------------------
load data
infile *
replace
into table clob_xml
fields terminated by ','
(
fname filler char(40),
xmldoc lobfile(fname) terminated by eof
)
begindata
'd:xmldocmydoc0.xml'
-----------------------------
and went to the bin dirctory and run this sqlldr command ...
D:oracleproduct10.1.0Db_1BIN>sqlldr scott/tiger control=work.ctl

after that i got this error

SQL*Loader: Release 10.1.0.2.0 - Production on �� 8 23:32:04 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL*Loader-500: Unable to open file (work.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

so what u think i did wrong??

Regards

Report message to a moderator

Re: using sqlloader to loading xml file [message #74572 is a reply to message #74571]

Sun, 09 January 2005 03:05

Amal
Messages: 9
Registered: January 2005

Junior Member

hi again....
plz ppl try to help me, i got no response tell now!!

Report message to a moderator

Re: using sqlloader to loading xml file [message #74573 is a reply to message #74571]

Sun, 09 January 2005 06:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>and through notepad i write this code and save it by name work.ctl
>>SQL*Loader-500: Unable to open file (work.ctl)

Make sure you have the file called work.ctl
You might have saved the file as work.ctl.txt.

when you look windows explorer, things look good.
Look in command prompt.

Report message to a moderator

Re: using sqlloader to loading xml file [message #74667 is a reply to message #74572]

Tue, 01 February 2005 11:01

Rich
Messages: 14
Registered: March 2002

Junior Member

Be sure to put the work.ctl file in your oracle/bin directory - the same directory that you see when you type SQL>host ... if you can't see work.ctl when you use the host command, you can't run it without a path when the loader asks for a control file

Report message to a moderator

Re: using sqlloader to loading xml file [message #74727 is a reply to message #74571]

Wed, 09 February 2005 01:03

Shafiqur
Messages: 1
Registered: February 2005

Junior Member

SQL*Loader: Release 10.1.0.2.0 - Production on ǡӈʠ��푠8 23:32:04 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL*Loader-500: Unable to open file (work.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

Report message to a moderator

Re: using sqlloader to loading xml file [message #110382 is a reply to message #74727]

Mon, 07 March 2005 03:21

_simma_dba
Messages: 34
Registered: November 2003

Member

You can run sqlldr from any dir if you want. So, go to directory where your *.ctl file is and then start sqlldr Cool

[Updated on: Mon, 07 March 2005 07:25]

Report message to a moderator

Previous Topic:	SQLLDR: Delimiter included in textfield
Next Topic:	using sql loader for XML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 18:37:45 CST 2024