袁腾飞成吉思汗全集:10g flashback table学习
来源:百度文库 编辑:九乡新闻网 时间:2024/10/06 15:39:25
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 TableThe prerequisites for performing a
----------
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;
FLASHBACK ANY TABLE
system privilege or you must have the FLASHBACK
object privilege on the table. SELECT
, INSERT
, DELETE
, and ALTER
privileges on the table. FLASHBACK TABLE
operation. 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--管理学习