OraFAQ Forum: Spatial » Local Spatial Index

Home » Server Options » Spatial » Local Spatial Index (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Local Spatial Index [message #587631]

Mon, 17 June 2013 09:39

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

Report message to a moderator

Re: Local Spatial Index [message #587657 is a reply to message #587631]

Mon, 17 June 2013 15:26

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Local Spatial Index [message #587974 is a reply to message #587657]

Wed, 19 June 2013 10:27

_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;

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 20:17:29 CST 2024