--数据库闪回(delete删除表回退)
ALTER TABLE ACRM_F_CI_SQU_ORG_LVL ENABLE ROW movement
FLASHBACK TABLE ACRM_F_CI_SQU_ORG_LVL TO TIMESTAMP to_timestamp('2017-7-19 1:50:20','yyyy-mm-dd hh24:mi:ss');
SELECT SYSDATE FROM dual
有个前提条件就是:Oracle数据已经开启该功能
--数据库闪回(delete删除表回退)
ALTER TABLE ACRM_F_CI_SQU_ORG_LVL ENABLE ROW movement
FLASHBACK TABLE ACRM_F_CI_SQU_ORG_LVL TO TIMESTAMP to_timestamp('2017-7-19 1:50:20','yyyy-mm-dd hh24:mi:ss');
SELECT SYSDATE FROM dual
有个前提条件就是:Oracle数据已经开启该功能
转载于:https://www.cnblogs.com/SteveNoah/p/8571664.html