alter table xxx enable row movement;
flashback table xxx to timestamp to_timestamp('2010-07-07 11:40:00','YYYY-MM-DD HH24:MI:SS');
FLASHBACK TABLE EMP TO SCN 10194235671
2: SELECT * FROM tableName AS OF
TIMESTAMP TO_TIMESTAMP(‘20070920083059’,‘yyyymmddhh24miss’) WHERE …..;
3: SELECT * FROM tableName AS OF SCN 4122650073 WHERE …..;
SELECT * FROM FMIS.ENM_CHARACTERCONTENT AS OF TIMESTAMP TO_TIMESTAMP('2010-07-09 16:20:00','YYYY-MM-DD HH24:MI:SS')
SELECT * FROM FMIS.ENM_CHARACTERCONTENT AS OF TIMESTAMP TO_TIMESTAMP('2010-07-08 16:40:00','YYYY-MM-DD HH24:MI:SS')
SELECT * FROM CHANNEL.IC_STORE_CHECKBILL AS OF TIMESTAMP TO_TIMESTAMP('2011-03-31 09:30:00','YYYY-MM-DD HH24:MI:SS')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-691436/,如需转载,请注明出处,否则将追究法律责任。