[20180321]ORA-08180.txt

最新推荐文章于 2023-12-15 10:55:47 发布

转载最新推荐文章于 2023-12-15 10:55:47 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/605701

文章标签：

#数据库

本文探讨了ORA-08180错误的原因及解决方案，通过具体实例展示了在不同时间间隔下查询Oracle数据库时遇到的问题。指出错误与时间映射表匹配失败有关，并建议尝试使用更长的时间间隔。

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