This discussion is archived
1 Reply Latest reply: Sep 11, 2012 7:50 AM by Jason_(A_Non) RSS

Making Changes to the XSD

user10863631 Newbie
Currently Being Moderated
Solaris: 5.10
Ver: 11.2.0.2

Hi.

We are prototyping a solution to capture all components of an invoice. The option to register an xsd and create a table with a(x) xmltype column is ideal for our immediate needs. The question being posed, however, is this:

If we implement our current xsd and capture data for a number of months, then we find a need to change the schema (xsd)...what are our options? What happens to the data that was already in place before the new schema changes came along? Do we have to drop and re-create table with the xmltype column that would be registered against the changed xsd?

Any help or advice on this would be appreciated.

-abe
  • 1. Re: Making Changes to the XSD
    Jason_(A_Non) Expert
    Currently Being Moderated
    The best place to start with this would be the documentation
    [url http://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb07evo.htm#ADXDB4680]XML Schema Evolution
    I have not done it myself, but it comes up time to time over on the {forum:id=34} forum. Should you have any additional questions on this topic, that forum is the appropriate place to ask.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points