Database Administration (MOSC)

MOSC Banner

ORA-29861

edited Jan 19, 2011 8:12AM in Database Administration (MOSC) 3 commentsAnswered
Hi,

I am updating a geometric point and am getting the following errors :

SQL> update meshuser.mps m set m.geometry.sdo_gtype = 2001, m.geometry.sdo_srid = 8307;
update meshuser.mps m set m.geometry.sdo_gtype = 2001, m.geometry.sdo_srid = 8307
                *
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE 

All the indexs I saw were valid ? 

Ideas ?

Thanks

Jeff

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