Re: Oracle XMLType

From: <nomorekiss_at_gmail.com>
Date: 16 Jul 2006 02:47:24 -0700
Message-ID: <1153043244.305365.275990@p79g2000cwp.googlegroups.com>

You should store you XML documents structured as XML type. To be short, that means registering your XML schema in database (if you don't have it you can generate one from XML documents with XML tools - XML Spy for example) and then importing XML documents in schema where you registered XML schema.
You can do that (import documents) with FTP, WEBdav or SQL*plus. Registering schema creates object table underneath and you can index attributes of that table later for performance reasons.

It might take some time to get it right but it is worth it.

To get started you should read some documentation first: http://www.oracle.com/technology/tech/xml/xmldb/Current/TWP_Mastering_XMLDB_Storage.pdf

I have started with 9i ( you need to be running at least 9.2.0.3 for this ) and used "basic demo" for tutorial. You can find it here: http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html ... under " Oracle9i R2 XML DB Demonstration"

If you have any problems with basic demo installation you can search for solutions on OTN forums. Received on Sun Jul 16 2006 - 04:47:24 CDT