Migrating xml schemas from 10.2.0.3 to 11.2.0.2
We are doing regular exports and imports trying to migrate these xml schemas.
SQL>SELECT OWNER, LOCAL, SCHEMA_URL FROM DBA_XML_SCHEMAS where owner = 'COR_OWNER';
OWNER LOC SCHEMA_URL
----------------------------------------------------------------------------------------------------
COR_OWNER NO
http://myurl/schemas/cor/globalmetadataschema
COR_OWNER NO
http://myurl/schemas/cor/globalrrschema
******* You can see the tables are in the xml schema
SQL>SELECT TABLE_NAME FROM DBA_XML_TABLES
2 WHERE XMLSCHEMA = 'http://myurl/schemas/cor/globalrrschema';
TABLE_NAME
------------------------------
LOGIN605_TAB
NAME606_TAB
OPTIONAL603_TAB
POST_SUBMISSION609_TAB
PUBLIC_KEY608_TAB
SUBMISSION_INFO615_TAB
HASH600_TAB
IMAGE604_TAB
EMAIL599_TAB
COMPUTER_IP594_TAB