Tag Archives: insert

ORA-7445(lnxadd)错误

Posted on 2012/10/23 by yangtingkun

一个由于低版本JDBC驱动导致的错误。 告警日志中错误信息为： Fri Aug 12 19:00:03 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_28464.trc: ORA-07445: exception encountered: core dump [lnxadd()+471] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Fri Aug 12 19:00:04 2011 Trace dumping IS performing id=[cdmp_20110812190004]Fri Aug 12 19:00:03 2011 … Continue reading →

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

ORA-600(ktspfupdst-1)错误

Posted on 2012/05/01 by yangtingkun

客户9208数据库出现ORA-600[ktspfupdst-1]错误。 错误信息为： Sat Mar 31 02:50:48 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_1896900.trc: ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operationSat Mar … Continue reading →

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

插入LOB对象的方法

Posted on 2011/12/23 by yangtingkun

其实以前写过类似的文章，但是都是在其他例子中，没有专门针对这个问题进行过描述，最近发现，还有很多人不清楚，插入一个包含LOB对象的记录需要几个步骤。 在客户的环境中，发现插入一条包含LOB的记录，居然用了四个步骤： SQL> CREATE TABLE T_LOB (ID NUMBER, NAME VARCHAR2(30), CONTENTS CLOB); 表已创建。 SQL> DECLARE 2 V_CLOB CLOB; 3 V_STR VARCHAR2(32767) := LPAD(’A’, 4000, ‘A’); 4 BEGIN 5 INSERT INTO T_LOB 6 VALUES (1, ‘A’, EMPTY_CLOB()); 7 SELECT CONTENTS 8 … Continue reading →

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