设为首页收藏本站

Botang唐波's Oracle Station

查看: 1071|回复: 0

(52-30)第49次上完1Z0-053第10章,2016-02-25星期四

[复制链接]

60

主题

98

帖子

1461

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1461
发表于 2016-2-26 16:43:30 | 显示全部楼层 |阅读模式
http://124.16.180.178:8080/studentguide_sec_O11g/

游客,本帖隐藏的内容需要积分高于 100 才可浏览,您当前积分为 0



  1. select *
  2.   from flashback_transaction_query q
  3. where q.logon_user = 'HR'
  4.    and q.table_name = 'TAB

  5. ;

  6. ---
  7. alter database add supplemental log data;
  8. ---
  9. select * from tab$ where rowid = 'AAAAACAABAAAPh9AAA';

  10. select * from dba_objects o where o.object_id = '80573';
  11. ---
  12. select t.row_movement
  13.   from dba_tables t
  14. where t.owner = 'HR'
  15.    and t.table_name = 'EMPLOYEES';

  16. ---

  17. select d.SUPPLEMENTAL_LOG_DATA_MIN,
  18.        d.SUPPLEMENTAL_LOG_DATA_PK,
  19.        d.SUPPLEMENTAL_LOG_DATA_UI,
  20.        d.SUPPLEMENTAL_LOG_DATA_FK,
  21.        d.SUPPLEMENTAL_LOG_DATA_ALL

  22.   from v_$database d;

  23. alter database add supplemental log data(primary key) columns;

  24. ----

  25. select * from hr.regions;

  26. select versions_xid,
  27.        versions_operation,
  28.        versions_startscn,
  29.        region_id,
  30.        region_name
  31.   from hr.regions versions between scn minvalue and maxvalue
  32. order by versions_startscn;



  33. begin
  34.    dbms_flashback.transaction_backout(numtxns => 1,
  35.                                                     xids => sys.xid_array('03001F00B8050000'),
  36.                               options => dbms_flashback.nocascade_force);
  37. end;

  38. rollback;
  39.                         
  40. select  * from dba_flashback_txn_report;

  41. select  * from dba_flashback_txn_state;

  42. select * from hr.regions;

  43. -------






  44. select versions_xid,
  45.        versions_operation,
  46.        versions_startscn,
  47.        id

  48.   from hr.tnocascade_force versions between scn minvalue and maxvalue
  49. order by versions_startscn;
  50. ---

  51. select *
  52.   from flashback_transaction_query q
  53. where q.logon_user = 'HR'
  54.    and q.table_name = 'NONCONFLICT_ONLY'    order by commit_scn ;


  55. select  * from dba_flashback_txn_report;

  56. --050020006D060000
  57. begin
  58.    dbms_flashback.transaction_backout(numtxns => 1,
  59.                                                     xids => sys.xid_array('0700090031050000'),
  60.                               options => dbms_flashback.nonconflict_only);
  61. end;

复制代码


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Botang唐波's Oracle Station   

GMT+8, 2018-12-13 12:15 , Processed in 0.093695 second(s), 27 queries .

快速回复 返回顶部 返回列表