Year: 2007
April 8

HOWTO: Manually create a XMLType table (OR / Schema based)

The Mark Drake Method (first steps to success)

begin
 dbms_xmlschema.registerSchema
(schemaURL => 'http://www.gralike.com/marco/HistorieWW/WWBase.xsd'
,schemaDoc => xdbURIType('/public/HistorieWW/WWBase.xsd').getClob()
,local     => FALSE
,genTypes  => TRUE
,genBean   => FALSE
,genTables => TRUE
);
end;
/
Read the postHOWTO: Manually create a XMLType table (OR / Schema based)
April 8

HOWTO: Compile a XML Schema in XMLDB

April 7

HOWTO: Move a XMLType column (based on CLOB storage) to different tablespace

The following is a just one of my weird 😉 thinking patterns I want to write down here.

Therefore this is one of my first “scratchpad” exercises. maybe more will follow.

I hope it will help someone out there who is trying the same stuff…

Timing is done to see what the performance is; Tablespace storage details where checked by me to see, check overall results / demonstrate behavior.

Read the postHOWTO: Move a XMLType column (based on CLOB storage) to different tablespace