What Privileges Are Needed To Do A Flashback Transaction Backout ?
Last updated on OCTOBER 24, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168
This problem can occur on any platform.
trans_arr := sys.xid_array('&1');
dbms_flashback.transaction_backout (numtxns => 1,xids => trans_arr,options =>dbms_flashback.cascade,scnhint => 7643000);
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_FLASHBACK", line 37
ORA-06512: at "SYS.DBMS_FLASHBACK", line 70
ORA-06512: at line 5
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms