首页 > 代码库 > 【练习】闪回表

【练习】闪回表

2024-08-26 13:18:40   212人阅读

1.删除表dept1：

13:09:30 SCOTT@ORA11GR2>select * from dept1;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 xxx            xxxx

13:09:47 SCOTT@ORA11GR2>delete from dept1;

4 rows deleted.

13:12:51 SCOTT@ORA11GR2>commit;

Commit complete.

2.允许行移动（使用flashback table 必须先允许行移动）

13:12:56 SCOTT@ORA11GR2>alter table dept1 enable row movement;

Table altered.

3.闪回表：

13:13:19 SCOTT@ORA11GR2>flashback table dept1 to timestamp to_timestamp(‘2016-11-11 13:09:47‘,‘yyyy-mm-dd hh24:mi:ss‘);

Flashback complete.

13:15:28 SCOTT@ORA11GR2>select * from dept1;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 xxx            xxxx

 

【练习】闪回表


联系
我们