PDA

View Full Version : What is the fastest way to import XML to Oracle 9i

Heinz Zastrau
12-03-2004, 05:45 AM
Hello,

I am looking for the fastest way to import an 1G-Byte XML to Oracle 9i
(ONIX-Format, Book-Catalogue). After import I want to retrieve the data
via SQL and Delphi. What are your hints? Thanks in advance.

Ciao Heinz Z.
Daniel Morgan
12-03-2004, 06:15 PM
Heinz Zastrau wrote:
Hello, I am looking for the fastest way to import an 1G-Byte XML to Oracle 9i (ONIX-Format, Book-Catalogue). After import I want to retrieve the data via SQL and Delphi. What are your hints? Thanks in advance. Ciao Heinz Z.

SQL*Loader direct path load.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
Heinz Zastrau
12-07-2004, 12:14 AM
DA Morgan <damorgan@x.washington.edu> schrieb am Fri, 03 Dec 2004 18:15:28
-0800:
SQL*Loader direct path load

thanks for the hint. With your information I have found this document:

https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10825/ldr_modes.htm

and read this:

The following features are not available with direct path load:
-- Loading a parent table together with a child table

Can't I fill via SQL*Loader and Direct Path Load a master and a detail
tabel?

Have somebody an example of importing XML-Data with SQL*Loader and Direct
Path Load or a hint where I can find one?

--
Ciao Heinz Z.
Daniel Morgan
12-07-2004, 08:13 AM
Heinz Zastrau wrote: DA Morgan <damorgan@x.washington.edu> schrieb am Fri, 03 Dec 2004 18:15:28 -0800: SQL*Loader direct path load thanks for the hint. With your information I have found this document: https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10825/ldr_modes.htm and read this: The following features are not available with direct path load: -- Loading a parent table together with a child table Can't I fill via SQL*Loader and Direct Path Load a master and a detail tabel? Have somebody an example of importing XML-Data with SQL*Loader and Direct Path Load or a hint where I can find one? -- Ciao Heinz Z.

Disable the constraint before the load if that is possible.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service