Oracle修改数据库提交之后进行回滚

-- 查询你执行update 语句之前的数据 精确到什么时间

select * from 表名 as of timestamp to_timestamp('2017-07-21 17:16:38', 'yyyy-mm-dd hh24:mi:ss');

-- 开启可移动数据命令,执行完就可以回滚数据

alter table 表名 enable row movement;

--正式回滚 update 语句前的数据

flashback table 表名 to timestamp TO_TIMESTAMP('2017-07-21 17:16:38', 'yyyy-mm-dd hh24:mi:ss');

 

评论 (2) -

  • Hello,
    If you are receiving this message it is because we have visited your site, and we think that your content is amazing! Really engaging and original, you should have worked so hard to generate such quality content.

    In Foremedia we love partnering up with people that generate great content and quality traffic, so we want to help you to monetize it better. If you become our partner, we will let you use our Premium ADX License, and you will get paid per visits to your website and no per clicks on the ads, so your revenue will be increased up to 45%.

    We love your content, for that reason we want you to make the best of it!

    If you are interested, email Jannine, our Business Development Representative at jannine@foremedia.net or visit our site to register. Our team will contact you by phone, Skype, or mail.

    Have a good day!

    Click the link here to learn more: https://foremedia.net/start
  • Hello,
    If you are receiving this message it is because we have visited your site, and we think that your content is amazing! Really engaging and original, you should have worked so hard to generate such quality content.

    In Foremedia we love partnering up with people that generate great content and quality traffic, so we want to help you to monetize it better. If you become our partner, we will let you use our Premium ADX License, and you will get paid per visits to your website and no per clicks on the ads, so your revenue will be increased up to 45%.

    We love your content, for that reason we want you to make the best of it!

    If you are interested, email Jannine, our Business Development Representative at jannine@foremedia.net or visit our site to register. Our team will contact you by phone, Skype, or mail.

    Have a good day!

    Click the link here to learn more: https://foremedia.net/start