PACKAGE: SYS.DBMS_FLASHBACK_ARCHIVE

Source

1 package dbms_flashback_archive AUTHID CURRENT_USER as
2 
3 -- FDA Disassociation
4 procedure disassociate_fba(owner_name VARCHAR2, table_name VARCHAR2);
5 procedure reassociate_fba(owner_name VARCHAR2, table_name VARCHAR2);
6 
7 -- FDA context
8 procedure set_context_level(level VARCHAR2);
9 function get_sys_context(xid raw, namespace varchar2, parameter varchar2)
10 return VARCHAR2;
11 procedure purge_context;
12 
13 -- Extends time mappings to times in the past
14 procedure extend_mappings;
15 
16 --User generated History
17 -- creates a table called temp_history with the correct definition in schema
18 procedure create_temp_history_table (owner_name1 IN VARCHAR2,
19                                      table_name1 IN VARCHAR2) ;
20 
21 -- Import History constants
22 nodrop    constant binary_integer := 1;
23 nocommit  constant binary_integer := 2;
24 nodelete  constant binary_integer := 4;
25 
26 -- imports history from a table called temp_history in the given schema
27 procedure import_history (owner_name1 IN VARCHAR2, table_name1 IN VARCHAR2,
28                           temp_history_name IN VARCHAR2 default 'TEMP_HISTORY',
29                           options IN BINARY_INTEGER default 0);
30 
31 -- DB Hardening
32 procedure register_application(Application_name IN VARCHAR2,
33                                flashback_archive_name IN VARCHAR2 default '');
34 procedure add_table_to_application(Application_name IN VARCHAR2,
35                                    table_name IN VARCHAR2,
36                                    schema_name IN VARCHAR2 default '');
37 procedure remove_table_from_application (Application_name IN VARCHAR2,
38                                        table_name IN VARCHAR2,
39                                        schema_name IN VARCHAR2 default '');
40 procedure enable_application(Application_name IN VARCHAR2,
41                              flashback_archive_name IN VARCHAR2 default '');
42 procedure disable_application(Application_name IN VARCHAR2);
43 procedure lock_down_application(Application_name IN VARCHAR2);
44 procedure unlock_application(Application_name IN VARCHAR2);
45 procedure drop_application(Application_name IN VARCHAR2);
46 procedure enable_at_valid_time(level IN VARCHAR2,
47                                query_time in TIMESTAMP default SYSTIMESTAMP);
48 procedure disable_asof_valid_time;
49 
50 end;