How to Specify Nologging for Spatial Index Creation
(Doc ID 135046.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Spatial and Graph - Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to 11.1]Information in this document applies to any platform.
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |