AnsweredAssumed Answered

migrating data to oracle geodatabase 11.1

Question asked by abdelhakim2015 on Jan 11, 2019
Latest reply on Jan 16, 2019 by abdelhakim2015

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the following message:

One or more object failed to paste. Table not registered. Underlying DBMS error [ORA-00932 : inconsistent datatypes; expected : %got% TableName]

The TableName contains a field of blob type; I've increased the value of MAXBLOBSIZE column in sde.server_config but it's still displaying the same error.

I'm using ArcGIS for Desktop 10.2, Oracle 11.1

Outcomes