Hello Experts, We have version 11.2.0.4 of Oracle. Saw similar questions in another discussion. We are having an issue encountered during partition exchange. We see column or type mismatch error even no difference in structure between main table and exchange table . And it appears a buggy behaviour as described in below doc as case -5 (mainly in cases where the base table has gone through a ALTER and added new not null column to it ). We are trying to fix that by setting event 14529 at session level as it's mentioned in the doc.
While setting that event to avoid the issue related to partition exchange , we are encountering "ORA-01031: insufficient privileges" at run time. This is getting set in a plsql procedure which is part of a package.
We also are able to do alter session set 'parallel_force_local' true, from the same user/schema which is holding the package. So we want to understand , if any different permission is required to set the 14529 event here inside plsql procedure?
Common Causes of ORA-14097 At Exchange Partition Operation (Doc ID 1418545.1)
SQL> BEGIN
2 EXECUTE IMMEDIATE 'alter session set events ''14529 trace name context forever, level 2''';
3 end;
4 /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 2