What is the fastest way to import XML to Oracle 9i

3 Dec 2004 1:45 PM

Heinz Zastrau

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.

4 Dec 2004 2:15 AM

DA Morgan

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
damor***@x.washington.edu
(replace 'x' with 'u' to respond)

7 Dec 2004 8:14 AM

Heinz Zastrau

DA Morgan <damor***@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.

7 Dec 2004 4:13 PM

DA Morgan

Heinz Zastrau wrote:
Show quote

> DA Morgan <damor***@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
damor***@x.washington.edu
(replace 'x' with 'u' to respond)