This content has been marked as final. Show 2 replies
Pl provide details on how you are migrating, along with the exact error messages from the "issue" you are facing. The more details you provide, the better the quality of the responses from forum members.
I was looking for best-practices and advice from DBA's who have done this conversion.
Here's one option that was suggested by Oracle Support:
1. Do a table level export of each XMLType table from the 10g DB
2. Manually register the XML schema in the target database
3. Recreate the tables in the target database
4. Import the data with the DATA_ONLY=Y which will ignore all DDL in the dump file and only insert the rows into the table