Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > Oracle 9i XML schema modification

Thread Tools

Oracle 9i XML schema modification

Posts: n/a
I realize this may be too Oracle specific for this forum-- but I've
seen a fair amount of postings related to ORacle 9i's XML capabilites
so I thought I'd give it a shot.

So, I've read in Oracle's documentatino for 9iR2 that if you want to
store schema based XML documents in Oracle, you first have to register
the schema. The problem is that if you want to modify the schema, and
then subsequently re-register it Oracle will force you to drop the
existing schema and delete all of the objects/tables/data associated
with it. Ok, fair enough, I can see how it would be hard to support
the ability to make any change to an XML schema and have Oracle
automagically mirgate the data to the new format.

But what if I just want to make relatively simple changes-- like
adding an additional text attribute to the schema? Could I "get
around" this limitation by manually doing an alter type on the
underlying objects and then changing then carefully updating Oracle's
copy of the schema to be in synch w/ this new underlying attribute
(but not re-registering the schema)? I can't think of why not-- but
what are your thoughts on this?
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
web.xml / XML schema issue, why do some XML schema attributes disappear Java 3 02-20-2007 09:56 AM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
[XML Schema] Including a schema document with absent target namespace to a schema with specified target namespace Stanimir Stamenkov XML 3 04-25-2005 09:59 AM
XML Schema to XML Schema Conversion Hari Om XML 1 03-02-2004 09:04 PM
XML schema regular expressions question and recommended XML Schema book Fred Smith XML 1 02-05-2004 11:12 AM