回收站(recyclebin)及回滚

mac2022-06-30  113

1、

alter table table_name enable row movement;

flashback table table_name  to timestamp  to_timestamp('2017-09-25','yyyy-mm-dd hh24:mi:ss');

alter table table_name disable row movement;

2、

select * from table_name as of timestamp to_timestamp('2017-09-25','yyyy-mm-dd hh24:mi:ss');

转载于:https://www.cnblogs.com/iyoume2008/p/7611256.html

最新回复(0)