Migration 8.1.6 to 9.2 with Spatial on SUN Solaris

HI NW,

We want to migrate Oracle 8.1.6 with Spatial Catridge to Oracle 9.2 with Spatial too.
We use the fullexport and fullimport from 8.1.6 to 8.1.7, because you can't migrate direct to 9.2. And we want export from 8.1.7 and import to 9.2.
Following is my problem. I get an error when i make a fullimport to 8.1.7.
The Spatial Index creation get failed.

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13203: failed to read USER_SDO_GEOM_METADATA table
ORA-13203: failed to read USER_SDO_GEOM_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7
ORA-06512: at line 1

I have check the Indezes after the import. The indezes with the creation name exist and are valid. Could it be that the Spatial indezes are really valid?

I have read all documents in Metalink, i had try all i known. I created a view SDO_GEOM_METADATA as select from USER_SDO_GEOM_METADATA.
I made a entry in the USER_SDO_GEOM_METADATA for the column on this i will create the Spatial_index. Nothing helps, can you help me?

thanks ahead Received on Fri Jan 17 2003 - 04:02:34 CST