Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle XMLType
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
![]() |
![]() |