PACKAGE: SYS.DBMS_FLASHBACK

Source

1 package dbms_flashback AUTHID CURRENT_USER as
2 
3  ----------------
4  -- OVERVIEW
5  -- Procedures for enabling and disabling dbms_flashback.
6  --
7  ---------------------------
8  -- PROCEDURES AND FUNCTIONS
9 
10 procedure enable_at_time(query_time in TIMESTAMP);
11 procedure enable_at_system_change_number(query_scn in NUMBER);
12 procedure disable;
13 function  get_system_change_number return NUMBER;
14 
15 -- Transaction backout constants
16 nocascade        constant binary_integer := 1;
17 nocascade_force  constant binary_integer := 2;
18 nonconflict_only constant binary_integer := 3;
19 cascade          constant binary_integer := 4;
20 
21 -- Transaction backout interfaces
22 procedure transaction_backout(numtxns number,
23                               xids    xid_array,
24                               options binary_integer default nocascade,
25                               scnhint number         default 0);
26 procedure transaction_backout(numtxns  number,
27                               xids     xid_array,
28                               options  binary_integer default nocascade,
29                               timehint timestamp);
30 procedure transaction_backout(numTxns number,
31                               names   txname_array,
32                               options binary_integer default nocascade,
33                               scnhint number         default 0);
34 procedure transaction_backout(numTxns  number,
35                               names    txname_array,
36                               options  binary_integer default nocascade,
37                               timehint timestamp);
38 
39 end;