question

user-237 (google) 1 avatar image
user-237 (google) 1 asked

Which is the Best way to load XML into Oracle XML DB

Hi, our application needs to send xml files via ftp to the Oracle server where they're stored. I'm looking for the most efficient way how to deal with this problem. My idea is that the files will be sent via ftp using a pl/sql procedure and java to the XML DB repository, then Oracle file watcher will invoke the external tables mechanism, which will transfer the data to an XML-aware table, where the files are internally decomposed into relational tables according to the XML schema, which is registered to this table. I read everywhere that external tables feature is together with SQL Loader the fastest way of loading data. Is this a possible solution? Or are there any reasonable alternatives? Please correct me if I am wrong.

tablesplsqlschemametadata
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leigh Riffel avatar image Leigh Riffel commented ·
I suggest you ask this on http://dba.stackexchange.com/.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.