[20180321]ORA-08180.txt

[20180321]ORA-08180.txt

$ oerr ora 08180
08180, 00000, "no snapshot found based on specified time"
// *Cause: Could not match the time to an SCN from the mapping table.
// *Action: try using a larger time.

1.环境:

SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SCOTT@book> select count(*) from emp as of timestamp sysdate -397;
select count(*) from emp as of timestamp sysdate -397
                     *
ERROR at line 1:
ORA-08180: no snapshot found based on specified time

SCOTT@book> select count(*) from emp as of timestamp sysdate -396;
  COUNT(*)
----------
        14

--//找另外的机器测试:
> select count(*) from scott.emp as of timestamp sysdate -5;
  COUNT(*)
----------
        14

> select count(*) from scott.emp as of timestamp sysdate -6;
select count(*) from scott.emp as of timestamp sysdate -6
                           *
ERROR at line 1:
ORA-08180: no snapshot found based on specified time

> select count(*) from scott.emp as of timestamp sysdate -5.0387;
select count(*) from scott.emp as of timestamp sysdate -5.0387
                           *
ERROR at line 1:
ORA-08180: no snapshot found based on specified time

--//并没有报ora-1555错误.也就是闪回查询也是受限制,理论讲很少有人查询这么长时间间隔的信息.