Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Selecting from view (by another scheme) doesn't use spatial index

679545Jan 13 2009 — edited Jan 19 2009
Hello,

I'm using XE to store spatial data. Data are in my general_scheme. I created restricted_scheme+ just with basic privileges to access the data.

The problem starts when I'm selecting data by restricted_schema+ from general_scheme.view+ - I notised that select operation don't use spatial index of the table and select is too slow (f.g. 30 sec. per one select). When I'm selecting data by restricted_scheme+ from data_scheme.table+, everything goes well.

Is that a bug?
It relates just to spatial index.
I tested these events on Oracle 11g and there was no problem with selecting by restricted_scheme.

Thanks for advices.

Lukas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2009
Added on Jan 13 2009
3 comments
263 views