While migrating data from Oracle 126.96.36.199 RAC to Oracle 188.8.131.52 RAC using Data Pump, the import failed with ORA-01460:
ORA-39097: Data Pump job encountered unexpected error -12801 ORA-39065: unexpected master process exception in MAIN ORA-12801: error signaled in parallel query server PZ99, instance oda2:PROD2 (2) ORA-01460: unimplemented or unreasonable conversion requested Job "USER_SCHEMA"."SYS_IMPORT_FULL_01" stopped due to fatal error at 02:29:54
As far as I know the ORA-01460 is triggered in relation to a function like TO_DATE, TO_CHAR or TO_NUMBER. Why would any of these be used during a plain export/import operation?
Any idea as to what could cause this error, or how to get more information?