Home » Server Options » Spatial » Local Spatial Index (oracle 11g)
Local Spatial Index [message #587631] Mon, 17 June 2013 09:39 Go to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
Hi,

I have a table and there are about 4 categories. I have created partitions on this table for each category.
I tried to create LOCAL spatial index using the following script.

SQL> CREATE INDEX SHIPPER.SHIP_GEOX ON SHIPPER.SHIPPER_CONSIGNMENTS(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('LAYER_GTYPE=POINT,TABLESPACE=DEV_IDX')LOCAL
(PARTITION P_EAST
PARAMETERS('LAYER_GTYPE=POINT,TABLESPACE=DEV_IDX'),
PARTITION P_WEST
PARAMETERS('LAYER_GTYPE=POINT,TABLESPACE=DEV_IDX')
)
/

When I execute I get the following error

Sql> ORA-29850: Invalid option for creation of domain indexes.

Is it true that LOCAL spatial indexes can only be created on "RANGE PARTITIONS"?

Please let me know your opinion.

Thanks
Re: Local Spatial Index [message #587657 is a reply to message #587631] Mon, 17 June 2013 15:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
My Spatial knowledge is close to nothing so I can't help much.

Oracle saysQuote:
ORA-29850: invalid option for creation of domain indexes

Cause: The user specified an invalid option like ASC, DESC, SORT or a parallel clause, partitioning clause or physical attributes clause.

Action: Choose one of the valid clauses for creation of domain indexes.

Now, if your "PARTITION P_EAST" (or P_WEST) mean "partitioning clause", then it appears that you chose an invalid syntax.
Re: Local Spatial Index [message #587974 is a reply to message #587657] Wed, 19 June 2013 10:27 Go to previous message
_jum
Messages: 577
Registered: February 2008
Senior Member
Don't repeat the PARTITION clause in the INDEX (only in the TABLE):
CREATE INDEX SHIPPER.SHIP_GEOX 
    ON SHIPPER.SHIPPER_CONSIGNMENTS(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS('LAYER_GTYPE=POINT,TABLESPACE=DEV_IDX') LOCAL;


Previous Topic: Area of Country
Next Topic: Move segments of a partitioned table containing SDO_GEOMETRY
Goto Forum:
  


Current Time: Thu Mar 28 11:26:01 CDT 2024