error sql at level 1 insufficient privilage oracle

Question

SQL> flashback table ticket to timestamp TO_TIMESTAMP('13-11-2018 22:30:56', 
                                                      'dd-mm-yyyy hh24:mi:ss');
flashback table ticket to timestamp TO_TIMESTAMP('13-11-2018 22:30:56', 
            *                                    'dd-mm-yyyy hh24:mi:ss')

ERROR at line 1:

ORA-00604 : error occurred at recursive SQL level 1

ORA-01031 : insufficient privileges

P.S. : I already added flashback any table system privilege.

Answer 1

Most probably you have a trigger such as after event type which contains some operations that prevent you perform your command line operations related with them. Try to disable those triggers, and then retry flashback table ...

To detect the obstacle, use :

select owner, trigger_name
  from user_triggers -- for current schema, might be replaced with "dba_triggers" for the whole
 where trigger_type = 'AFTER EVENT';