0 Replies Latest reply on Feb 28, 2013 11:01 AM by 952738

    Dbms_Xmlschema Copyevolve

      (10gR2) I have a schema based xmltype column inside an audit table.

      Name Null Type
      ------------------------------ -------- ---------------------------------------

      A new Schema is now in place and I want to register the new schema and use the existing table and columns to insert these new XMLs. I used Dbms_Xmlschema.Copyevolve with a stylesheet and works perfectly. I now have fully validated XMLs against the new Schema.

      However, copyevolve drops the old Schema and registers the new schema using the old schema URI.

      Is there a way for copyevolve to rename the schema URI?

      The problem I have is that new XMLs being parsed are using the new schemaLocation name.