Hi,
I exported a schema from Oracle 11.2.0.1 and trying to import it in Oracle 12c. My Oracle schema contains xml schema and xmltype columns in a table. My xml fragment is
<Tag0> <Tag1>
<Tag2 Id="10202" date1="2017-11-15T13:36:34.000000" date2="2017-11-15T13:36:34.000000"/>
</Tag1> </Tag0>
This data is exported from Oracle 11 successfully but failed to load in Oracle 12c and also in same Oracle 11 database with following error-
ORA-31693: Table data object "myschema"."mytable" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30992: error occurred at Xpath /Tag0/Tag1[1]/Tag2[1][@date2]
ORA-01858: a non-numeric character was found where a numeric was expected
I am using expdp and impdp commands for export and import.
Thanks,
-Bhupen
It's possible this is caused by an unpublised bug. This incorrectly formats timestamps with trailing full stops. It's fixed in 12.1.
To see if this is the issue and for a possible workaround, see if you can insert the data over a database link, like so:
insert into t@db12c
select * from t@db11g