[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错误.也就是闪回查询也是受限制,理论讲很少有人查询这么长时间间隔的信息.
