This content has been marked as final. Show 2 replies
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