Oracle Locator Does Not Get Upgraded Automatically During Database Migration From 10.1 To 10.2.0.1 Or 10.2.0.2
(Doc ID 363421.1)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version 10.2.0.1 to 10.2.0.2 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2013***
- Oracle Enterprise Edition without Spatial but Oracle Locator installed
- Oracle Standard Edition
- After upgrading database from 10.1 to 10.2.0.1 or 10.2.0.2 Spatial Indexes cannot be dropped or recreated without errors
- Errors that can be seen:
ERROR at line 1 : ORA-29856: error occurred in the execution of ODCIINDEXDROP routine ORA-29400: data cartridge error ORA-00942: table or view does not exist ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 27and
ERROR at line 1 : ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-06550: line 1, column 8: PLS-00201: identifier 'MDSYS.MDPRVT_IDX' must be declared ORA-06550: line 1, column 8: PL/SQL: Statement ignored ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
Database upgrade from 10.1 to 10.2.0.1 or 10.2.0.2
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document