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?

Report message to a moderator

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: 9100
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."

Report message to a moderator

Previous Topic: How to search within a polygon
Next Topic: Size of Spatial Data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 02:12:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.