CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_FBT

Version 11.1
 
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;
 
Related Topics
FLASHBACK
FLASHBACK TABLE
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [270 users online]    © 2010 psoug.org