-- 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" ;
70032