-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: dblink
通过数据库链指定AS OF SCN语句
一直不确定闪回查询的AS OF语句是否可以通过数据库链对远端数据库生效,而由于通过数据库链查询会使两个数据库的SCN同步,使得这个问题难以测试。 通过数据库链查询会导致源和目标库SCN同步:https://yangtingkun.net/?p=722 虽然Oracle会在通过数据库链执行查询或DML操作时同步数据库的SCN,但是指定的SCN是本地的还是远端的还是有意义的。 为了说明这种情况,创建一个JOB,定期进行数据的修改,以快速提高一个数据库的SCN: SQL> SELECT dbid, name FROM v$database; DBID NAME ———- ——— 452011237 ORAT2 SQL> SELECT COUNT(*) FROM t; COUNT(*) ———- 731791 SQL> BEGIN 2 FOR i IN 1..100000 loop 3 INSERT INTO t VALUES (i, ‘y’); … Continue reading
11.2通过数据库链调用10.2过程报错
测试中无意发现了这个bug,在11.2数据库通过数据库链,执行10.2.0.1上的过程,结果出现ORA-06553: PLS-801: internal error [55916]的错误。 错误可以通过下面的例子重现: -bash-3.2$ sqlplus / AS sysdba SQL*Plus: Release 10.2.0.1.0 – Production ON Mon Sep 12 23:12:47 2011 Copyright (c) 1982, 2005, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 – … Continue reading