oracle闪回数据
方法一 数据删除了:
select * from t_test as of timestamp to_timestamp('2011-10-25 13:45:00','yyyy-mm-dd hh24:mi:ss')
方法二 表被drop掉了,到垃圾回收站找:
SELECT * FROM DBA_RECYCLEBIN WHERE original_name LIKE '%G_WAIT%';
CREATE TABLE contractbilling_wait_0323 AS
SELECT * FROM "BIN$S15/52dhVdXgUAB/AQBSjg==$0";