Is This Content Helpful?
We're glad to know this article was helpful.
When importing an Oracle dump (export) file that contains SDO_GEOMETRY data, the import program may not populate the rows in USER_SDO_GEOM_METADATA for the tables with SDO_GEOMETRY columns. Also, the spatial indexes cannot be created, because the index creation routines need the missing rows from USER_SDO_GEOM_METADATA.
This is a known issue with Oracle export and import utility at version 8.1.7.x.
Upgrade to Oracle 9i, or install the Oracle 18.104.22.168 database patch. For Oracle 22.214.171.124, install the corresponding Oracle Spatial patch, which must match the level of the core database server patch on Oracle 8i systems.
Refer to Oracle MetaLink or Oracle Technical Support for further details.