Importing an XML File into Oracle 10G XE - Oracle

In many cases, exporting a table to create an XML file is easy, but importing an XML file to create a table is much more difficult. This is true for Oracle 10G XE, as you will see in this article.

TABLE OF CONTENTS:

By: Jayaram Krishnaswamy

Poor Best

Rating:

/ 6

December 20, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

Let us say we want to import an XML file as shown in the next picture. This XML file was generated by exporting a table from an MS Access application.

Simplifying the test further

The MS Access created file has Microsoft Namespace references, details of columns, and so forth. In this format the Load into Oracle will fail. From experience the XML document loading error messages in Oracle 10G XE do not give much help to the user. This help would have been very useful as the user does not know what to do next. Hence for this tutorial the following simplified procedure was used.

The idea is to create a table, export it as an XML document and try to load it to the same table with different data. The rest of the steps do show that this at least succeeds.

Next: Importing a simplified, contrived XML file >>