--恢复方法1
SELECT * FROM user_info AS OF TIMESTAMP to_timestamp('2018-06-12 12:00:00')
INSERT INTO user_info(SELECT * FROM user_info_temp AS OF TIMESTAMP to_timestamp('2018-06-12 12:00:00'))
SELECT * FROM user_info_temp AS OF TIMESTAMP to_timestamp('2018-06-12 12:00:00')
INSERT INTO user_info_temp(SELECT * FROM user_info_temp AS OF TIMESTAMP to_timestamp('2018-06-12 12:00:00'))
--恢复方法2
ALTER TABLE user_info_temp ENABLE ROW MOVEMENT
FLASHBACK TABLE user_info_temp TO TIMESTAMP to_timestamp('2018-06-12 12:00:00')
ALTER TABLE user_info_temp DISABLE ROW MOVEMENT
oracle数据恢复
于 2018-08-05 17:43:08 首次发布