General |
Source |
{ORACLE_HOME}/rdbms/admin/dbmstxin.sql |
First Available |
10.1 |
Data Types |
CREATE OR REPLACE TYPE flashbacktblist
AS VARRAY(100) OF VARCHAR2(30);
/
TYPE TMPTBCURTYPE IS REF CURSOR; |
Dependencies |
DBMS_ASSERT |
FLASHBACKTBLIST |
DBMS_FBT_LIB |
PLITBLM |
DBMS_SQL |
|
|
Security Model |
Execute is granted to PUBLIC with
AUTHID CURRENT_USER |
|
FBT_ANALYZE |
Undocumented |
dbms_fbt.fbt_analyze(
table_name IN VARCHAR2,
flashback_scn IN NUMBER,
tmptbcur OUT TMPTBCURTYPE); |
set
serveroutput on
DECLARE
rc dbms_fbt.tmptbcurtype;
rc_rec VARCHAR2(100);
BEGIN
dbms_fbt.fbt_analyze('T',
dbms_flashback.get_system_change_number, rc);
/*
FOR i IN 1 .. 1 LOOP
FETCH rc
INTO rc_rec;
-- dbms_output.put_line(rc_rec(1));
END LOOP;
*/
END;
/ |
Undocumented |
dbms_fbt.fbt_analyze(
table_name IN VARCHAR2,
flashback_time IN TIMESTAMP,
tmptbcur OUT TMPTBCURTYPE); |
TBD |
|
FBT_EXECUTE |
Undocumented |
dbms_fbt.fbt_execute(
table_names IN FLASHBACKTBLIST,
flashback_scn IN NUMBER); |
CREATE TABLE t (
testcol DATE)
ENABLE ROW MOVEMENT;
DROP TABLE t;
SELECT object_name, original_name
FROM recyclebin;
DECLARE
n NUMBER :=
dbms_flashback.get_system_change_number;
tl sys.flashbacktblist;
BEGIN
tl := sys.flashbacktblist();
tl.EXTEND;
tl(1) := 'BIN$T3g70YjBQ4uB0J+C/NEptw==$0';
dbms_fbt.fbt_execute(tl, n);
END;
/ |
Undocumented |
dbms_fbt.fbt_execute(
table_names IN FLASHBACKTBLIST,
flashback_time IN TIMESTAMP); |
TBD |
|
FBT_DISCARD |
Purge |
dbms_fbt.fbt_discard; |
exec
dbms_fbt.fbt_discard; |