This content has been marked as final. Show 4 replies
1 person found this helpful
It would appear that because the schemas were registered under different database schemas, they are somehow seen as incompatible.Possibly.
Is this the case or do they actually not match in some other way? Is there an easy way to compare them?Are both XML schemas identical?
If so, why not register only one globally and give access to both DB schemas?
Does XML instances have xsi:schemaLocation or xsi:noNamespaceSchemaLocation attributes?
Are they the same?
A test case would be welcome actually.
Edited by: odie_63 on 3 oct. 2012 18:50
Thanks! The only place we use schemaLocation is to import an external schema which is, again, the same in both database schemas. What particular information would be helpful: the XSD which we register? I appreciate the help!
What particular information would be helpful: the XSD which we register?Yes, including the one you import (if not too big), or a simplified version if possible?
BTW, is it Object-Relational or Binary XML storage?
Thanks for the feedback. I think that you have led us in the right direction. We have the same schema registered twice, once under the owner of each table. I am working with our DBAs now to create a test version of these tables using a globally-registered version of the schema. I will post the results.