Home » Server Options » Spatial » Creting local spatial index on list partition (oracle 11g)
Creting local spatial index on list partition [message #599996] Wed, 30 October 2013 14:22 Go to next message
gentleman777us
Messages: 122
Registered: April 2005
Senior Member
I tried to create LOCAL spatial index on LIST partitioned table. it is throwing me error "ORA-029850: Invalid option for creation of domain indexes".

Is it possible to create LOCAL spatial index on LIST Partitioned table? if so can someone give me the syntax.

Note: I was able to create LOCAL spatial index for range partition but not for LIST partition. Looks like oracle doesn't support it. any thoughts?
Re: Creting local spatial index on list partition [message #600026 is a reply to message #599996] Wed, 30 October 2013 21:41 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
http://docs.oracle.com/cd/E16655_01/appdev.121/e17896/sdo_index_query.htm#SPATL586

"The following restrictions apply to spatial index partitioning:
...
Only range partitioning is supported on the underlying table. All other kinds of partitioning are not currently supported for partitioned spatial indexes."
Previous Topic: How to search within a polygon
Next Topic: Size of Spatial Data
Goto Forum:
  


Current Time: Thu Mar 28 17:36:43 CDT 2024