Home arrow Oracle arrow Page 3 - Loading and Unloading XML Files Using Oracle 10G XE

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:
  1. Loading and Unloading XML Files Using Oracle 10G XE
  2. From Table to XML
  3. Importing an XML File into Oracle 10G XE
  4. Importing a simplified, contrived XML file
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 6
December 20, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: