Oracle Table With XMLTYPE
-- Oracle Table With XMLTYPE datatype
-- The chunk size will be in multiples of 2x values
-- and 4000 gets adjusted to 4096 (i.e 212)

CREATE TABLE cms_xmldata
(content_id       NUMBER,
 content_desc     XMLTYPE)
XMLTYPE content_desc STORE AS CLOB
 (TABLESPACE ts_xd01
  STORAGE (INITIAL 6144
           NEXT    6144)
    CHUNK 4000
  NOCACHE LOGGING);


CREATE TABLE cms_xmldata
(content_id       NUMBER,
 content_desc     XMLTYPE)
 XMLTYPE    content_desc STORE AS SECUREFILE CLOB
 (TABLESPACE  ts_xd02
  STORAGE (INITIAL 6144)
  CACHE);


CREATE TABLE cms_xmldata
(content_id       NUMBER,
 content_desc     XMLTYPE)
XMLTYPE content_desc STORE AS OBJECT RELATIONAL
   XMLSCHEMA "http://www.oratnt.com/cmsxmldata.xsd"
     ELEMENT "content"
;


Oracle registered trademark of Oracle Corporation.

Last Revised On: September 01, 2014

  7605