Re: Privilege Error while setting event

From: Pap <oracle.developer35_at_gmail.com>
Date: Sun, 17 Oct 2021 00:24:17 +0530
Message-ID: <CAEjw_fjPVK9A9=E6SujrdPXvGizWnVchzXM=ZkfsQWVCnRWD0g_at_mail.gmail.com>



Do you see the entry in DBA_SYS_PRIVS for that user with privilege='ALTER SESSION'? On Sat, Oct 16, 2021 at 9:13 PM Lok P <loknath.73_at_gmail.com> wrote:

> 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-l
Received on Sat Oct 16 2021 - 20:54:17 CEST

Original text of this message