课程第18次（2017-04-11星期二）

botang

1. select * from flashback_transaction_query   f
   
2. where f.table_name='TAB
   
3. 
   
4. and f.table_owner='SYS'
   
5. order by 4 desc;
   
6. /*
   
7. 3902349
   
8. 3902347
   
9. 3902344
   
10. */
    
11. 
    
12. select versions_xid,versions_operation, versions_startscn , salary
    
13. from hr.employees
    
14. versions between scn minvalue and maxvalue
    
15. where employee_id=101;
    
16. 
    
17. ---
    
18. select  * from dba_objects o
    
19.   where o.owner='HR' and o.object_name='T05310_DDL';
    
20.   
    
21.   --75885
    
22.   
    
23.   drop table hr.t05310_ddl purge;
    
24.   ---
    
25.   select  d.SUPPLEMENTAL_LOG_DATA_MIN,
    
26.              d.SUPPLEMENTAL_LOG_DATA_PK,
    
27.              d.SUPPLEMENTAL_LOG_DATA_UI,
    
28.              d.SUPPLEMENTAL_LOG_DATA_FK,
    
29.              d.SUPPLEMENTAL_LOG_DATA_ALL
    
30.    from v_$database d;
    
31.    
    
32.   alter database add supplemental log data (primary key) columns;
    
33.   
    
34.   select   f.xid, count(*)   from flashback_transaction_query   f
    
35. where f.table_name='EMPLOYEES' and f.table_owner='HR'
    
36. and f.logon_user='HR'
    
37.   group by f.xid;
    
38.   
    
39.   select * from flashback_transaction_query   f
    
40. where f.table_name='T_CASCADE' and f.table_owner='HR'
    
41. order by 4 desc;
    
42.   
    
43. begin
    
44.    dbms_flashback.transaction_backout(1,xid_array('0500110070090000'),
    
45.     options =>dbms_flashback.cascade
    
46.       );
    
47. end;
    
48. 
    
49. select  * from dba_flashback_txn_report;
    
50. 
    
51. select  * from dba_flashback_txn_state;
    
52. 
    
53. commit;

复制代码