摘要：
查看包的结构内容[oracle@arcerzhang ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Sun May 19 20:15:32 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaConnected.SQL> desc dbms_flashback_archive;PROCEDURE DISASSOCIATE_FBA Argument Name Type ... 阅读全文
摘要：
闪回数据版本查询->闪回数据归档查询，前者不可以跨越DDL操作，后者可以跨越.SQL> l 1 select versions_xid,to_char(versions_starttime,'yyyy-mm-dd hh24:mi:ss') versions_starttime,versions_endtime,empno,sal 2 from emp 3 versions between timestamp to_timestamp('2013-05-18 14:13:07','yyyy-mm-dd hh24:mi:ss') and 阅读全文