My Oracle Support Banner

What Privileges Are Needed To Do A Flashback Transaction Backout ? (Doc ID 794595.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


DBMS_FLASHBACK fails with ORA-1031 when executed by an user who is not granted the DBA role:

     trans_arr sys.xid_array;
     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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.