September 21st, 2012, 02:33 PM
How To Change Default XML Storage
As per the bellow the default XML storage has been changed in 11gr2.
Oracle Database 11g Release 2 (126.96.36.199) New Features in Oracle XML DB
The following Oracle XML DB features are new in Oracle Database 11g Release 2 (188.8.131.52).
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 (184.108.40.206), 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?