ORACLE 11G XMLTYPE Migration switchover

The process of xmltype migration and switching really depressed me for a long time, but the final solution is still good, and the solution has verified OK.

There are many restrictions on the export of xmltype tables, because the content formats of xml are still diverse, and oracle officials often tinker with them, but there are still some mistakes, so if you want to migrate xmltype tables in the future, the preferred steps are:

First, switch to the clob field.

For example: create table xxx_clob_tab as select t.xmltypecol.getclobval () xxx_clob from sourceXMLTab

II. Expdp/impdp the xxx_clob

III. Convert to xmltype

Note: the session created must be set up before conversion:

Disable BINARY XML storage and switch to CLOB based storage. The following event can be set at the destination host:

1. Alter system set events' 31156 trace name context forever, level 0x400'

Then covert it to xmltype

2. Create table xxx_xml as select sys.xmltype.createXML (clob column) as xmlcol from xxx_clob_tab