I’m using Redgate Data Compare for Oracle 5. I’ve (successfully) created Source and Target connections (both Oracle 11g), defined schema names on both side, then switched to "Tables & Views" tab. There was Initializing process popped-up, like connecting to db, populating metadata from oracle tables etc. and get list of tables from both connections. Later, I switched back to “main” screen "Data Sources" and changed one of the connections to another database (Oracle 12c). This time "Tables and Views" initialization failed with bunch of ORA errors.
ORA-19202: Error occurred in XML processing
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file PSImetalsParameters.csv in TEST not found
ORA-06512: at "SYS.DBMS_XMLGEN", line 288
ORA-06512: at "SYS.DBMS_XMLGEN", line 237
ORA-06512: at "SYS.DBMS_XMLGEN", line 280
ORA-06512: at line 1
(I have doubt that it may be some privileges issue for that user/schema. But not sure which Oracle tables or schemas RedGate needs to access.)
Any help on it?