Privilege Error while setting event
From: Lok P <loknath.73_at_gmail.com>
Date: Sat, 16 Oct 2021 21:13:15 +0530
Message-ID: <CAKna9VbQY5-Avz5RnNhWnsqdA3zij7dPoxPQgEBDhPA+Ziuf3A_at_mail.gmail.com>
We are hitting a buggy scenario while doing partition exchange. And it mainly appears when the base table has gone through an ALTER and added a new not null column to it using the first column add method. The property of the column changed and it doesn't match with the exchange table which is created using the CREATE table statement. To avoid the error we are setting the event below before creating the exchange table like it's explained in the blog below. But we are getting "ORA-01031: insufficient privileges" at run time , while setting this event in plsql procedure using execute immediate like below which is part of a package. The same procedure does have other ALTER statements like setting 'parallel_force_local' true, setting 'current_schema' etc. But all of those work fine. So I want to understand , what special permission is required to be able to set the 14529 event without error?
Date: Sat, 16 Oct 2021 21:13:15 +0530
Message-ID: <CAKna9VbQY5-Avz5RnNhWnsqdA3zij7dPoxPQgEBDhPA+Ziuf3A_at_mail.gmail.com>
We are hitting a buggy scenario while doing partition exchange. And it mainly appears when the base table has gone through an ALTER and added a new not null column to it using the first column add method. The property of the column changed and it doesn't match with the exchange table which is created using the CREATE table statement. To avoid the error we are setting the event below before creating the exchange table like it's explained in the blog below. But we are getting "ORA-01031: insufficient privileges" at run time , while setting this event in plsql procedure using execute immediate like below which is part of a package. The same procedure does have other ALTER statements like setting 'parallel_force_local' true, setting 'current_schema' etc. But all of those work fine. So I want to understand , what special permission is required to be able to set the 14529 event without error?
EXECUTE IMMEDIATE 'alter session set events ''14529 trace name context forever, level 2''';
https://connor-mcdonald.com/2016/02/16/exchange-partition-revisited/
Regards
Lok
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 16 2021 - 17:43:15 CEST