袁腾飞成吉思汗全集:10g flashback table学习

来源：百度文库 编辑：九乡新闻网 时间：2024/07/08 15:53:04
SQL> var scn numberSQL> exec :scn := dbms_flashback.get_system_change_numberPL/SQL 过程已成功完成。SQL> select count(*) from t;  COUNT(*)
----------
        26SQL> delete from t;已删除26行。SQL> commit;提交完成。SQL> select count(*) from t as of scn :scn;  COUNT(*)
----------
        26SQL> select * from (select count(*) from t), (select count(*) from t as of scn :
scn);  COUNT(*)   COUNT(*)
---------- ----------
         0         26SQL> flashback table t to scn :scn;
flashback table t to scn :scn
                *
第 1 行出现错误:
ORA-08189: 因为未启用行移动功能, 不能闪回表
SQL> select * from (select count(*) from t), (select count(*) from t as of scn :  2  scn);  COUNT(*)   COUNT(*)
---------- ----------
        26         26 SQL>  alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';会话已更改。
SQL> flashback table t to timestamp to_timestamp('2007-03-30:15:24:19','yyyy-m
m-dd:hh24:mi:ss');
 Prerequisites for Using Flashback Table

The prerequisites for performing a FLASHBACK TABLE operation are as follows:

  • You must have been granted the FLASHBACK ANY TABLE system privilege or you must have the FLASHBACK object privilege on the table.
  • You must have SELECT, INSERT, DELETE, and ALTER privileges on the table.
  • Undo information retained in the undo tablespace must go far enough back in time to satisfy the specified target point in time or SCN for the FLASHBACK TABLE operation.
  • Row movement must be enabled on the table for which you are issuing the FLASHBACK TABLE statement. You can enable row movement with the following SQL statement: 
    ALTER TABLE table ENABLE ROW MOVEMENT;

10g flashback table学习 oracle 10g table shrink table 英语学习大全G 英语学习口诀大全g 英语学习口诀大全G Oracle10g?flashback系列新特性之flashback?database Oracle10g?flashback系列新特性之flashback?drop Oracle10g?flashback系列新特性之flashback?version?qu... 4G领域先学习：什么是WiMAX 英语学习1038个词根g table UI patterns TABLE 517 057 Table边框使用总结 table 细 虚表格 Router Table Page Two EAI UFIDA TABLE Structure Table锁定行列 闪回丢弃（Flashback Drop） 治療腹瀉奇方---葛根10g、黃連6g、黃芩6g、白术6g、甘草3g ：枸杞5g、白芍3g、绿茶3g、冰糖10g。 功能 ```g 够您学习一辈子的生活经典g 系统盘清理2G垃圾的方法2--管理学习