topic Re: migrating data to oracle geodatabase 12c in Data Management Questions

migrating data to oracle geodatabase 11.1

GISiste — Fri, 11 Jan 2019 16:04:59 GMT

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

Re: migrating data to oracle geodatabase 12c

MichaelVolz — Fri, 11 Jan 2019 17:12:29 GMT

These are the requirements for Oracle against ArcGIS 10.3 (Could not find 10.2 link)

Oracle database requirements for ArcGIS 10.3.x—Help | ArcGIS Desktop

What is your specific version of 12c as 10.3 was only supported up to Oracle 12.1.0.1?

Re: migrating data to oracle geodatabase 12c

George_Thompson — Fri, 11 Jan 2019 17:30:12 GMT

Here are the system requirements for 10.2.x: https://resources.arcgis.com/en/help/system-requirements/10.2/#/Oracle_Database_Requirements/01510000006s000000/

Geodatabase‌

Re: migrating data to oracle geodatabase 12c

GISiste — Fri, 11 Jan 2019 17:37:38 GMT

I've tried from a machine with ArcGIS Desktop 10.5 and the same error was given.
in fact it's 11.1 Oracle version.

Re: migrating data to oracle geodatabase 11.1

BillFox — Fri, 11 Jan 2019 20:43:01 GMT

Do the simple table, point, line and polygons feature classes copy over without error?

ArcCatalog > Load option too?

Re: migrating data to oracle geodatabase 11.1

GISiste — Mon, 14 Jan 2019 09:17:09 GMT

Bill Fox‌ the copy operation progress until the error occurs.
Same error with Load option

Re: migrating data to oracle geodatabase 11.1

BillFox — Mon, 14 Jan 2019 16:31:06 GMT

Hello Abdelhakim,

How about create a new empty feature class in the new geodatabase using one of the feature classes as a template.

Verify you can edit it to create and delete a few features.

Then try load or append again.

Re: migrating data to oracle geodatabase 11.1

GISiste — Wed, 16 Jan 2019 14:02:44 GMT

Well, thank you for your answers. This has been solved. Indeed, I switched the type of spatial data storage from SDEBINARY to ST_GEOMETRY and had to modify the table sd.dbtune and update the value of the column VARIABLE_BINARY to contain BLOB instead of LANGRAW

Migration de données d'un type de stockage à un autre—Aide | ArcGIS Desktop