Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Question Unanswered: How To Change Default XML Storage


    As per the bellow the default XML storage has been changed in 11gr2.

    What's New in Oracle XML*DB?

    Oracle Database 11g Release 2 ( New Features in Oracle XML DB

    The following Oracle XML DB features are new in Oracle Database 11g Release 2 (

    Default Storage Model for XMLType

    The default XMLType storage model is used if you do not specify a storage model when you create an XMLType table or column. Prior to Oracle Database 11g Release 2 (, unstructured (CLOB) storage was used by default. The default storage model is now binary XML storage.
    We have a application which works fine on r1 but not on r2 due to this change, we are going to investigate resolving the issue on the application in the future, in the mean time we need to be able to use the CLOB storage.

    Does any one know where we can change this functionality back to the pre 11gR2 change?


  2. #2
    Join Date
    Feb 2006
    Provided Answers: 1
    You might can use the 'XMLCAST' function.
    But we really need more info, Show us some example code of what is failing...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts