My Oracle Support Banner

ORA-01031: insufficient privileges MDSYS procedure MDSYS.SET_EVENT_FOR_PARTITIONING (Doc ID 3072398.1)

Last updated on FEBRUARY 19, 2025

Applies to:

Oracle Database - Standard Edition - Version 19.25.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.25.0.0.0 version, RDBMS

ORA-13249 after application of Spatial Bundle Patch 37492905


ORA-13249: begin /* pexec_cmt_idx_chngs */ mdsys.prvt_idx.cmt_idx_chngs(:idxsch, :idxnam, :idxptn, :tsnam, :tabnam, :ins_no, :del_no, :jnl, :sid); end;
ORA-00604: error occurred at recursive SQL level 3
ORA-06550: line 1, column 33:
PLS-00306: wrong number or types of arguments in call to ''CMT_IDX_CHNGS''
ORA-06550: line 1, column 33:
PL/SQL: Statement ignored

ERROR
-----------------------
ORA-13249

Installing the Spatial got the error

ERROR=UNABLE to set level=0 : CURRENT_USER=MDSYS

ORA-01031: insufficient privileges: call stack:

----- PL/SQL Call Stack -----
object line
object
handle number name
0xac4df808 21 procedure
MDSYS.SET_EVENT_FOR_PARTITIONING
0xb59a08e0 57 anonymous block

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.