Cannot Create Intermedia Index In Specified Tablespace

[Robertio]

Any ideas appreciated:

CREATE INDEX SPROLIVE.IDXCALLARCHCOMMENTS
ON SPROLIVE.CALLARCH(CAL_COMMENTS) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('storage Sproliveidxwordindex')

It is exactly the same command (copied and pasted) as we used on a previous install of Oracle 817 where it worked. Now trying to run it on a new server - Windows Server 2003, clean install yesterday, it is coming back with:

ORA-29855: error occurred in the execution of ODCIINDEX CREATE routine
ORA-20000: interMedia Text error:
DRG-10700: preference does not exist: Sproliveidxwordindex
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1

If I take the last line out so that it puts the index in the SYSTEM tablespace it creates fine, however, I know the Sproliveidxwordindex tablespace exists and if I change it to any other created tablespace it throws the same error.

Any help/advice appreciated as this is driving me insane.





Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk

 

[Robertio]

In case it is ever of any use to anyone else:

Eventually tracked down that the storage parameter required a schema, so:

CREATE INDEX SPROLIVE.IDXCALLARCHCOMMENTS
ON SPROLIVE.CALLARCH(CAL_COMMENTS) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('storage SPROLIVE.Sproliveidxwordindex')

Works fine. Can only guess our normal configuration file was not copied across for this database.


Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk