Oracle数据库表根据时间戳(AS OF TIMESTAMP)备份数据

AS OF TIMESTAMP SYSDATE - 1
AS OF TIMESTAMP TO_TIMESTAMP('2016-06-22 12:30:00','YYYY-MM-DD HH24:MI:SS')
CREATE TABLE [TABLENAME] AS SELECT * FROM (SELECT * FROM [TABLENAME] AS OF TIMESTAMP SYSDATE - 1);

原文地址:https://www.cnblogs.com/Dream-Lasting/p/8991065.html