How To Drop Partition Update Global Indexes From Different Schema In 10g DB ? (Doc ID 2301539.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5.0 to 10.2.0.5.0 [Release 10.2]
Information in this document applies to any platform.

Goal

The DROP PARTITION TABLE UPDATE GLOBAL INDEXES fails with "ORA-01031: insufficient privileges" in 10.2.0.5 database

 

 

 

StackError Trace shows it's failing on the Insert statement when updating the referenced object:


ksedmp: internal or fatal error
ORA-01031: insufficient privileges
Current SQL statement for this session:
insert /*+ RELATIONAL(TABLE_INTERACT) PARALLEL(TABLE_INTERACT,1) APPEND */ into "SURAPR_OP"."TABLE_INTERACT" partition ("TABLE_INTERACT_20170630") select /*+ RELATIONAL(TABLE_INTERACT) PARALLEL(TABLE_INTERACT,1) */ * from "SURAPR_OP"."TABLE_INTERACT" partition ("TABLE_INTERACT_20170708") delete global indexes
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssd_unwind_bp: unhandled instruction at 0x769dad instr=f
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?

 

 SQL> select * from dba_sys_privs where grantee='SURAPR_BG';

GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SURAPR_BG ALTER ANY TABLE NO
SURAPR_BG CREATE SESSION NO

Solution

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