1.删除表里的某条数据再恢复回来,10GORACLE.
select * from t_qx_qxxx as of timestamp sysdate -1;--一天,
2. DROP 表 再恢复回来 SELECT * FROM RECYCLEBIN --相当于垃圾箱功能.
FLASHBACK TABLE T_QX_QXXX TO BEFORE DROP;--回恢复DROP前的数据.
1.删除表里的某条数据再恢复回来,10GORACLE.
select * from t_qx_qxxx as of timestamp sysdate -1;--一天,
2. DROP 表 再恢复回来 SELECT * FROM RECYCLEBIN --相当于垃圾箱功能.
FLASHBACK TABLE T_QX_QXXX TO BEFORE DROP;--回恢复DROP前的数据.