nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

migrating data to oracle geodatabase 11.1

GISiste

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

Find more posts tagged with

Accepted answers

GISiste

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

All comments

MikeVolz

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?

George_Thompson

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

Geodatabase‌

GISiste

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.

BillFox

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

ArcCatalog > Load option too?

GISiste

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

BillFox

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.

GISiste

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.