How to Specify Nologging for Spatial Index Creation (Doc ID 135046.1)

Last updated on JANUARY 16, 2013

Applies to:

Oracle Spatial - Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Jan-2013***


Symptoms

You want to specify nologging for spatial index creation and specified the keyword at the end, but get syntax errors as shown below:

create index shapes_idx on shapes(geometry) 
indextype is mdsys.spatial_index 
nologging

nologging
*
ERROR at line 3:
ORA-29850: invalid option for creation of domain indexes

You then tried to specify it in PARAMETERS string and get a different error: 

create index shapes_idx on shapes(geometry)
indextype is mdsys.spatial_index
parameters('nologging')

create index shapes_idx on shapes(geometry)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13201: invalid parameters supplied in CREATE INDEX statement
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms