cross-schema Index Spatial Creation Fails with Ora-00942
Last updated on JUNE 01, 2014
Applies to:Oracle Spatial and Graph - Version 22.214.171.124 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 126.96.36.199.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
Million Knowledge Articles and hundreds of Community platforms