cross-schema Index Spatial Creation Fails with Ora-00942
Last updated on JUNE 01, 2014
Applies to:Oracle Spatial and Graph - Version 18.104.22.168 and later
Information in this document applies to any platform.
User A have enough privilege on user B's table to create index.
But its failing with following error:
Database upgraded from 11.2 to 22.214.171.124.0.
On 11.2 index can be created without error by non table owner.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms