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/，如需转载，请注明出处，否则将追究法律责任。