先做个闪回查询试试:SELECT * FROM yourtable AS OF TIMESTAMP TO_TIMESTAMP('2009-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS');闪回查询的时间由UNDO_RETENTION来确定,单位是秒
1,求当前时间 SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;2,删除数据的表 - CM_EMPLOYEE_MB SELECT * FROM CM_EMPLOYEE_MB AS OF TIMESTAMP TO_TIMESTAMP('2008-08-21 18:21:49', 'YYYY-MM-DD HH24:MI:SS') WHERE SEX = 'F';(这种方式能得出删除的数据。)3,回复已删除数据 INSERT INTO CM_EMPLOYEE_MB (SELECT * FROM CM_EMPLOYEE_MB AS OF TIMESTAMP TO_TIMESTAMP('2008-08-21 18:21:49', 'YYYY-MM-DD HH24:MI:SS') WHERE SEX = 'F');
http://topic.csdn.net/u/20090204/22/327149ad-19ed-4ab5-8e50-6fa0c67a996b.html
AS OF TIMESTAMP TO_TIMESTAMP('2009-02-12 00:00:00', 'YYYY-MM-DD HH24:MI:SS');闪回查询的时间由UNDO_RETENTION来确定,单位是秒
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;2,删除数据的表 - CM_EMPLOYEE_MB
SELECT *
FROM CM_EMPLOYEE_MB AS OF TIMESTAMP TO_TIMESTAMP('2008-08-21 18:21:49', 'YYYY-MM-DD HH24:MI:SS')
WHERE SEX = 'F';(这种方式能得出删除的数据。)3,回复已删除数据
INSERT INTO CM_EMPLOYEE_MB
(SELECT *
FROM CM_EMPLOYEE_MB AS OF TIMESTAMP TO_TIMESTAMP('2008-08-21 18:21:49', 'YYYY-MM-DD HH24:MI:SS')
WHERE SEX = 'F');
如果被drop掉了,那直接到recycle中去拿吧.