Home » RDBMS Server » Server Utilities » Create schema & load data via XML files (V11. on Linux)
Create schema & load data via XML files [message #280446] Tue, 13 November 2007 11:51
Messages: 25533
Registered: January 2009
Location: SoCal
Senior Member
I've been given 2 XML files, abc.xsd & abc.xml, which supposedly contain the table
definitions (xsd) and the actual table data (xml).

My challenge to figure how to create the tables & actually load the data into the tables.
I want these tables to be standard relational tables & not "XML" tables.

I am posting this in Utilities forum, because I suspect the solution will be some
sort of custom PL/SQL code calling some Oracle supplied stored procedure which will
do the necessary transformation.

If I can eventually create the tables & load the data directly from these 2 files;
that would be great.
Otherwise I'd be satisfied with creating text files containing valid SQL statements
for the CREATE & INSERT operations.

In case it matters, I hope to load this data into a new 11g DB on a Linux system.

I am ready, willing & able to RTFM, if somebody would be so kind as to point me at 1 or
more of the FM where such a process is described or where coding examples can be found.

Thanks In Advance

[Updated on: Tue, 13 November 2007 11:52] by Moderator

Report message to a moderator

Previous Topic: select table from dump
Next Topic: ERROR EXP-00003 During an Export!
Goto Forum:

Current Time: Mon Jul 24 11:59:32 CDT 2017

Total time taken to generate the page: 0.15901 seconds