ITPub博客

首页 > Linux操作系统 > Linux操作系统 > flashback as of example

flashback as of example

原创 Linux操作系统 作者:golden_zhou 时间:2011-04-01 08:03:37 0 删除 编辑

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

上一篇: 在SP查找特定SQL
下一篇: awr_script_example
请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    300886