PROBLEM
When importing an Oracle export file containing a table with an ST_Geometry attribute, the command fails with the Oracle error IMP-00060.
The following example demonstrates using the Oracle Import utility to import an Oracle export file named buildings.dmp. The dumpfile contains one table named buildings, which contains the attribute ST_Geometry and a st_spatial_index index on the ST_Geometry attribute.
Code:
C:\expdir> imp tb/tb file=buildings.dmp full=y
There is a type object identifier mismatch for the sde.st_geometry object exported from the origin database and the sde.st_geometry type object identifier in the destination import database.
When exporting a table from one Oracle database to a second Oracle database and the table contains a user-defined type for an attribute, for example, ST_Geometry, the type's object identifier value in the origin and destination databases must have the same value. If the object identifier values are not identical, Oracle considers the objects different and cannot import the table.
Article ID:000010431
Get help from ArcGIS experts
Download the Esri Support App