COUNT(*)

-----------------

0

1 row selected.

SCOTT@ORA12C> select count(*) from t1 as of timestamp to_timestamp(‘2015-09-20 14:54:00‘,‘yyyy-mm-dd hh24:mi:ss‘);

COUNT(*)

-----------------

91692

1 row selected.

SCOTT@ORA12C> flashback table t1 to timestamp to_timestamp(‘2015-09-20 14:54:00‘,‘yyyy-mm-dd hh24:mi:ss‘);

flashback table t1 to timestamp to_timestamp(‘2015-09-20 14:54:00‘,‘yyyy-mm-dd hh24:mi:ss‘) ? ? ? ? ? ? ? ?*

ERROR at line 1:

ORA-08189: cannot flashback the table because row movement is not enabled

SCOTT@ORA12C> alter table t1 enable row movement;

Table altered.

SCOTT@ORA12C> flashback table t1 to timestamp to_timestamp(‘2015-09-20 14:54:00‘,‘yyyy-mm-dd hh24:mi:ss‘);

Flashback complete.

SCOTT@ORA12C> select count(*) from t1;

COUNT(*)

-----------------

91692

1 row selected.

注意system表空間下面的表不能閃回，不能跨越DDL語句，

SYS@ORA12C> flashback table t2 to timestamp to_timestamp(‘2015-09-20 15:07:25‘,‘yyyy-mm-dd hh24:mi:ss‘);

flashback table t2 to timestamp to_timestamp(‘2015-09-20 15:07:25‘,‘yyyy-mm-dd hh24:mi:ss‘) ? ? ? ? ? ? ? ?*

ERROR at line 1:

ORA-08185: Flashback not supported for user SYS

但是可以查詢：

SYS@ORA12C> ?select count(*) from t2 as of timestamp to_timestamp(‘2015-09-20 15:07:25‘,‘yyyy-mm-dd hh24:mi:ss‘);

COUNT(*)

-----------------

91694

1 row selected.

可以重新建一張表或者直接insert：

SYS@ORA12C> create table t3 as select * from t2 as of timestamp to_timestamp(‘2015-09-20 15:07:25‘,‘yyyy-mm-dd hh24:mi:ss‘);

Table created.

SYS@ORA12C> insert into t2 select * from t2 as of timestamp to_timestamp(‘2015-09-20 15:07:25‘,‘yyyy-mm-dd hh24:mi:ss‘);

91694 rows created.

@ORA12C> commit;

Commit complete.

oracle的閃回查詢，閃回刪除：

標(biāo)簽：oracle閃回

本條技術(shù)文章來源于互聯(lián)網(wǎng)，如果無意侵犯您的權(quán)益請點(diǎn)擊此處反饋版權(quán)投訴 本文系統(tǒng)來源：http://7642644.blog.51cto.com/7632644/1696517

總結(jié)

以上是生活随笔為你收集整理的oracle删除闪回文件,oracle的闪回查询，闪回删除：的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。