[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錯誤.也就是閃回查詢也是受限制,理論講很少有人查詢這麼長時間間隔的資訊.