oracle 恢复表数据

来源:互联网 发布:北京软件人员工资水平 编辑:程序博客网 时间:2024/05/22 00:27


insert into table_name
  select *
    from table_name as of timestamp to_timestamp('20151110 11:06:00', 'yyyymmdd HH:mi:ss')
commit;
insert into v50_hjr_financing_application
  select *
    from v50_hjr_financing_application as of timestamp to_timestamp('20151110 11:06:00', 'yyyymmdd HH:mi:ss')
commit;
0 0
原创粉丝点击