Shulou(Shulou.com)06/01 Report--

Create table T1 as select * from dba_objects

SCOTT@ORA12C > select sysdate from dual

SYSDATE

-

2015-09-20 14:54:10

1 row selected.

SCOTT@ORA12C > delete from T1

0 rows deleted.

SCOTT@ORA12C > commit

Commit complete.

SCOTT@ORA12C > select count (*) from T1

COUNT (*)

-

0

1 row selected.

SCOTT@ORA12C > select count (*) from T1 as of timestamp to_timestamp ('2015-09-20 14 from 5400mm hh34:mi:ss')

COUNT (*)

-

91692

1 row selected.

SCOTT@ORA12C > flashback table T1 to timestamp to_timestamp ('2015-09-20 14-14-54-12-5-5-9-20-14-14-54-12-12-12-12-12-12-14-14-14-15-14-14-54-00-12-12-12-12-12-12-14-14-14-14-14-54-00-12-12-12-14-14-14-54-12-12-12-12-14-14-14-14-14-14-14-14-15-14-14-14-54-12-14-14-15-12-14-14-14-14-14-14-14-14-14-14-15-14-14-14-15-14-14-15-14-14-15-14-14-14-14-14-14-

Flashback table T1 to timestamp to_timestamp ('2015-09-20 14mord hh34: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-14-54-12-5-5-9-20-14-14-54-12-12-12-12-12-12-14-14-14-15-14-14-54-00-12-12-12-12-12-12-14-14-14-14-14-54-00-12-12-12-14-14-14-54-12-12-12-12-14-14-14-14-14-14-14-14-15-14-14-14-54-12-14-14-15-12-14-14-14-14-14-14-14-14-14-14-15-14-14-14-15-14-14-15-14-14-15-14-14-14-14-14-14-

Flashback complete.

SCOTT@ORA12C > select count (*) from T1

COUNT (*)

-

91692

1 row selected.

Note that tables under the system tablespace cannot be flashback and cannot span DDL statements

SYS@ORA12C > flashback table T2 to timestamp to_timestamp ('2015-09-2015: 07 purl 25mm hh34:mi:ss')

Flashback table T2 to timestamp to_timestamp ('2015-09-2015: 07 hh34:mi:ss') *

ERROR at line 1:

ORA-08185: Flashback not supported for user SYS

But you can query:

SYS@ORA12C > select count (*) from T2 as of timestamp to_timestamp ('2015-09-2015: 07 from 25mm hh34:mi:ss')

COUNT (*)

-

91694

1 row selected.

You can create a new table or simply insert:

SYS@ORA12C > create table T3 as select * from T2 as of timestamp to_timestamp ('2015-09-2015: 07 as select 25 hh34:mi:ss')

Table created.

SYS@ORA12C > insert into T2 select * from T2 as of timestamp to_timestamp ('2015-09-2015: 07 PUBG 25mm hh34:mi:ss')

91694 rows created.

@ ORA12C > commit

Commit complete.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.