Oracle环境下失误地删除数据 commit以后 恢复的方法。
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');
Oracle 数据恢复
最新推荐文章于 2024-09-14 21:52:32 发布