OraFAQ Forum: Server Utilities » using sql loader for XML

Home » RDBMS Server » Server Utilities » using sql loader for XML

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

using sql loader for XML [message #110405]

Mon, 07 March 2005 06:17

_simma_dba
Messages: 34
Registered: November 2003

Member

How can I use SqlLoader to load xml file into database. Cool

I know that there is new feature in 10g but I'm using 8i Confused

[Updated on: Mon, 07 March 2005 06:17]

Report message to a moderator

Re: using sql loader for XML [message #110426 is a reply to message #110405]

Mon, 07 March 2005 08:55

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

You can use SQL*Loader to load XML files into CLOB or BLOB columns. This would allow you to store your XML in the database, however, the database would not be able to do much with them (for that you need to upgrade).

For details, see the Oracle 8i Utilities Users Guide.

Best regards.

Frank

Report message to a moderator

Re: using sql loader for XML [message #110428 is a reply to message #110426]

Mon, 07 March 2005 09:21

_simma_dba
Messages: 34
Registered: November 2003

Member

THX a lot, I found some perl modul DBIx::XML::DataLoader that can parse XML file into *.dat file for using in sqlldr (they say so). That maybe can help me. Razz

Report message to a moderator

Previous Topic:	using sqlloader to loading xml file
Next Topic:	Export oracle 9 to oracle 10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:50:05 CDT 2024