Home » RDBMS Server » Server Administration » howto Change default XML Storage (11gR2)
icon5.gif  howto Change default XML Storage [message #566974] Fri, 21 September 2012 13:17 Go to next message
XMLTYPE
Messages: 4
Registered: September 2012
Location: Sunny CA
Junior Member
Hello,

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


docs.oracle.com/cd/E11882_01/appdev.112/e10492/whatsnew.htm

Quote:

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

The following Oracle XML DB features are new in Oracle Database 11g Release 2 (11.2.0.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 (11.2.0.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?

thanks
Re: howto Change default XML Storage [message #566977 is a reply to message #566974] Fri, 21 September 2012 13:39 Go to previous messageGo to next message
Michel Cadot
Messages: 67813
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#i2218838

Regards
Michel
Re: howto Change default XML Storage [message #566979 is a reply to message #566974] Fri, 21 September 2012 13:47 Go to previous messageGo to next message
XMLTYPE
Messages: 4
Registered: September 2012
Location: Sunny CA
Junior Member
Thanks, the issue is that the app creates the tables its self and the default on oracle has change.


It worked before it does not now, to change the app would be 100's of hours of development efforts, to change oracle would be a lot quicker.

We need to change the default oracle setting.

thanks
Re: howto Change default XML Storage [message #566980 is a reply to message #566979] Fri, 21 September 2012 14:03 Go to previous messageGo to next message
Michel Cadot
Messages: 67813
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to ask Oracle with an enhancement request but I don't think it will be accepted.

Regards
Michel
Re: howto Change default XML Storage [message #566982 is a reply to message #566980] Fri, 21 September 2012 15:30 Go to previous messageGo to next message
XMLTYPE
Messages: 4
Registered: September 2012
Location: Sunny CA
Junior Member
Thank you, we will talk to them.

I was hoping there was a "ALTER SESSION XMLTYPE STORAGE" type command.
Re: howto Change default XML Storage [message #566983 is a reply to message #566982] Fri, 21 September 2012 15:36 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
I don't do XML.
As a general rule, if/when you don't like any specific default value; just specify explicitly what you want instead when object is created.
Re: howto Change default XML Storage [message #566984 is a reply to message #566983] Fri, 21 September 2012 16:06 Go to previous messageGo to next message
XMLTYPE
Messages: 4
Registered: September 2012
Location: Sunny CA
Junior Member
The application we use is hardcoded with the default which have been working from Oracle 9g all the way through to 11gR1. At R2 they changed the default breaking our application.

We could
a) Spend hundreds of hours recoding out application
b) Change the default setting in oracle
c) Not use oracle 11gR2.

Since we already have installed Oracle 11gR2 it would be preferable to change the default setting in oracle. Alternatively we are going to have to revert to Oracle 11gR1, which also does not appeal due to the effort required to reinstall.

thanks

Re: howto Change default XML Storage [message #566991 is a reply to message #566984] Sat, 22 September 2012 00:19 Go to previous message
Michel Cadot
Messages: 67813
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'd go to a) and make it not relying on any default so that you can still use the same code with the next versions.

Regards
Michel
Previous Topic: ASM DISKGROUP RESIZE
Next Topic: Blocking Session in v$session
Goto Forum:
  


Current Time: Sat Apr 17 03:41:51 CDT 2021