Tag Archives: Materialized view

ORA-600(kghfrf1)错误

Posted on 2012/10/12 by yangtingkun

客户的10.2.0.4 FOR AIX数据库在刷新物化视图时碰到这个错误。 错误信息为： Fri Oct 5 06:20:27 2012 Errors IN file /home/oracle/app/admin/orcl/udump/orcl_ora_4272180.trc: ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], []Fri Oct 5 06:20:27 2012 Errors in file /home/oracle/app/admin/orcl/udump/orcl_ora_4272180.trc: ORA-00600: internal error code, arguments: [kghfrf1], … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

ORA-7445(kqlSubheapPin)错误

Posted on 2012/09/11 by yangtingkun

Oracle 10.2.0.4 for X86-64数据库出现ORA-7445[kqlSubheapPin]错误。 错误信息为： Tue Jul 26 13:27:05 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: core dump [kqlSubheapPin()+84] [SIGSEGV] [Address NOT mapped TO object] [0x000000110] [] []Tue Jul 26 13:27:05 2011 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment

ORA-600(qsmqSetupTableMetadata-2)错误

Posted on 2012/06/04 by yangtingkun

客户10.2.0.4 RAC for HP-UX 11.31在物化视图刷新时出现这个错误。 错误信息如下： Thu May 3 22:54:44 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-00600: internal error code, arguments: [qsmqSetupTableMetadata-2], [], [], [], [], [], [], [] Thu May 3 22:55:20 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-12012: error ON … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

10G开始Oracle区分物化视图和表

Posted on 2012/05/09 by yangtingkun

在9i以前，很多功能都是不区分表和物化视图的区别的，到了10g以后。很多功能会将表和物化视图区分对待。 原本通用的COMMENT ON TABLE语句，对物化视图不再有效，必须要使用COMMENT ON MATERIALIZED VIEW语句代替。 SQL> SELECT * FROM V$VERSION; BANNER —————————————————————- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS FOR Linux: Version 10.2.0.4.0 – Production NLSRTL Version … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

物化视图快速刷新不支持标准外联接写法

Posted on 2011/08/27 by yangtingkun

发现对于REFRESH FAST ON COMMIT物化视图，并不支持标准外连接的写法，而Oracle特有的(+)方式则没有问题。 Oracle对于标准外联接的写法支持的并不好，类似的bug已经不是第一次碰到了。 SQL> CREATE TABLE T_P (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30)); 表已创建。 SQL> CREATE TABLE T_F (ID NUMBER PRIMARY KEY, FID NUMBER); 表已创建。 SQL> CREATE MATERIALIZED VIEW LOG ON T_P 2 WITH ROWID (ID); 实体化视图日志已创建。 SQL> … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment