Re: Migration 8.1.6 to 9.2 with Spatial on SUN Solaris

Hans;

You may need to turn-on Spatial...

1. Shutdown the Instance ..
2. cd $ORACLE_HOME/rdbms/lib
3. make -f ins_rdbms.mk sdo_on
4. startup the instance..
5. USER_SDO_GEOM_METADATA will show up in the USER_UPDATABLE view as enabled..

HTH JP

Hans Klassen wrote:

> 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 Sat Jan 18 2003 - 11:12:42 CST