OraFAQ Forum: Server Administration » howto Change default XML Storage

Home » RDBMS Server » Server Administration » howto Change default XML Storage (11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

howto Change default XML Storage [message #566974]

Fri, 21 September 2012 13:17

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

Report message to a moderator

Re: howto Change default XML Storage [message #566977 is a reply to message #566974]

Fri, 21 September 2012 13:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#i2218838

Regards
Michel

Report message to a moderator

Re: howto Change default XML Storage [message #566979 is a reply to message #566974]

Fri, 21 September 2012 13:47

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

Report message to a moderator

Re: howto Change default XML Storage [message #566980 is a reply to message #566979]

Fri, 21 September 2012 14:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to ask Oracle with an enhancement request but I don't think it will be accepted.

Regards
Michel

Report message to a moderator

Re: howto Change default XML Storage [message #566982 is a reply to message #566980]

Fri, 21 September 2012 15:30

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.

Report message to a moderator

Re: howto Change default XML Storage [message #566983 is a reply to message #566982]

Fri, 21 September 2012 15:36

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: howto Change default XML Storage [message #566984 is a reply to message #566983]

Fri, 21 September 2012 16:06

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

Report message to a moderator

Re: howto Change default XML Storage [message #566991 is a reply to message #566984]

Sat, 22 September 2012 00:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	ASM DISKGROUP RESIZE
Next Topic:	Blocking Session in v$session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 23:15:26 CST 2024