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.
Get help from ArcGIS experts
Download the Esri Support App