数据回滚

alter table des_SYS_DATALINKDEFINE enable row movement;
flashback table des_SYS_DATALINKDEFINE to timestamp to_timestamp('2020-12-24 09:33:51', 'yyyy-mm-dd hh24:mi:ss');
alter table SYS_DATALINKDEFINE enable row movement;
flashback table SYS_DATALINKDEFINE to timestamp to_timestamp('2020-12-24 09:33:51', 'yyyy-mm-dd hh24:mi:ss');
alter table des_SYS_DATALINKDEFINE disable row movement;
alter table SYS_DATALINKDEFINE disable row movement;

参考 https://blog.csdn.net/weixin_43474476/article/details/107484706

posted @ 2020-12-25 11:12  可控核聚变  阅读(111)  评论(0)    收藏  举报