Oracle数据恢复

最新推荐文章于 2024-09-11 11:21:57 发布

mfw238

最新推荐文章于 2024-09-11 11:21:57 发布

阅读量71

点赞数

分类专栏： Oracle 文章标签： Oracle

Oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

SELECT *
　FROM FLASHBACK_TRANSACTION_QUERY t where t.table_name = 'TABLE_OPERATION'

insert into table_operation2  select * from table_operation as of timestamp 
to_timestamp('2009-9-21 09:00:00','yyyy-mm-dd hh24:mi:ss') where student_id in
(                       
    select t.student_id from table_operation t 
)

create table temptable as select * from table_operation as of timestamp to_timestamp('2009-9-21 09:00:00','yyyy-mm-dd hh24:mi:ss')

alter table jlxxt.table_operation enable row movement;
--alter database flashback on;
--flashback table jlxxt.table_operation to timestamp to_timestamp('2009-09-21 09:20:00','yyyy-mm-dd hh24:mi:ss');
--create table houhuitable as select *  from (select table_operation.* ,rownum rs from table_operation ) where rs>0
flashback table jlxxt.table_operation to timestamp to_timestamp('2009-09-22 08:06:00','yyyy-mm-dd hh24:mi:ss');
--