Spatial (MOSC)

MOSC Banner

I can't create a Cross-Schema partitioned spatial index

edited Mar 11, 2010 10:36PM in Spatial (MOSC) 1 commentAnswered
I’m trying to create a Cross-Schema partitioned spatial index (on a table that is not on my schema), fails with this error

SQL> create index SINPROC_CARTO.BORRA_SIDX on                                     
  2  SINPROC_CARTO.BORRA(G3E_GEOMETRY) indextype is mdsys.spatial_index LOCAL;
create index SINPROC_CARTO.BORRA_SIDX on
*
ERROR en línea 1:
ORA-29855: se ha producido un error en la ejecución de la rutina
ODCIINDEXCREATE
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in R-tree: [mdrcrtscrt]
ORA-13231: fallo al crear la tabla de índices [MDRT_70D0C$] durante la creación

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center