Home » RDBMS Server » Server Utilities » Create schema & load data via XML files (V11.1.0.6.0 on Linux)
Create schema & load data via XML files [message #280446] Tue, 13 November 2007 11:51
BlackSwan
Messages: 25039
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: Tue Dec 06 02:16:10 CST 2016

Total time taken to generate the page: 0.07507 seconds