Comments on: Oracle 11g – XMLType Storage Options

By: Amit

Amit — Thu, 01 Apr 2010 03:11:55 +0000

Hi,

Does dbms_xmlstore supports bulk binding for inserts?

By: Marco

Marco — Fri, 24 Jul 2009 08:34:55 +0000

Your requirements sound like a solution based on XMLType binary XML storage and indexed with an unstructured XMLIndex and with a possible second index on the XMLIndex Path Table, being a text index.

By: akhil

akhil — Wed, 22 Jul 2009 22:35:44 +0000

For instance such as complex data such as MARC or library data which has no rigid structure ..which is a character data…how we can store the character data in the semi structured data format?

By: Marco Gralike

Marco Gralike — Mon, 20 Jul 2009 15:52:18 +0000

It depends a bit on the XML document structure and/or if you are using an XML Schema.

If you are using an XML Schema then an XMLType table based on Object Relational storage would be an option, in conjunction with storing the unstructured data bit in a CLOB. This combination can be found in the manual, searching for XMLType “hybrid” storage.

Or if in 11g, you could also use Binary XML (with or without using an XML Schema)…

The best choice depends on the XML structure. In general the “hybrid” form would be the best way to go if in doubt.

By: akhil

akhil — Fri, 17 Jul 2009 17:43:18 +0000

hi,… how we can store data in semi structured storage

By: Marco Gralike

Marco Gralike — Mon, 15 Dec 2008 20:08:29 +0000

No not really, at least, not afaik. An “insert into” should do the trick.

Be aware though that you will have far more options to chose from while using binary XML storage: Encoding, support for 1 or multiple XML Schematas, securefile (=extra license) or basicfile clob, compression, deduplication, etc.

Really recommend Oracle 11.1.0.7.0 instead of 11.1.0.6.0 in this case

By: Nancy

Nancy — Mon, 15 Dec 2008 17:33:16 +0000

Hi,

Is there a recommended way to migrate data in a XML CLOB column in Oracle 10g to the binary XML column in Oracle 11g?
thanks
Nancy

By: Marco Gralike

Marco Gralike — Wed, 23 Apr 2008 05:21:50 +0000

You will know for sure / you can check for yourself via:

set long 1000000

select dbms_metadata.get_ddl('TABLE','CUSTOMERTYPETAB') 
from   dual;

By: ahmad

ahmad — Wed, 23 Apr 2008 03:28:12 +0000

when we have query like

CREATE TABLE CustomerTypeTab of XMLTYPE 
XMLSCHEMA "http://homepage/sample1" ELEMENT "Customer";

is it CLOB type or relational type. THANK U AGAIN

By: Marco Gralike

Marco Gralike — Tue, 22 Apr 2008 16:13:37 +0000

Reference can be found in the XMLDB Developers Guide, so for the latest information regarding the Binary XML storage model: the Oracle XMLDB Developers Guide v 11gR1. Also have a look here, especially the whitepaper references of database version 10g regarding storage methods..."Mastering XML DB Storage in Oracle Database 10g Release 2" BTW "ahmad" your email address is not valid, so I can't follow up on this.