 Oracle Page 3 - Loading and Unloading XML Files Using Oracle 10G XE |
Importing an XML File into Oracle 10G XE - OracleIn 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.
print this article SEARCH DEV SHED |
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.
blog comments powered by Disqus |
/ 6 
Importing a CSV Text File into Oracle 10G XE
