Tag Archives: truncate

ORA-600(KSSADP1)错误

客户9.2.0.8 RAC for AIX环境出现ORA-600[KSSADP1]错误。 错误信息为: Thu Apr 19 21:16:45 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], [] Thu Apr 19 21:16:45 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc: ORA-00600: internal error code, … Continue reading

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

TRUNCATE模式SQLLDR导致SECUREFILE的LOB空间不断增长

测试LOB的SECUREFILE存储方式时发现,如果利用SQLLDR的TRUNCATE方式导入数据,随着测试次数的增加,LOB对象占用的空间也会逐步增加。 创建表的脚本很简单: CREATE TABLE t_load_4m_sf (id NUMBER, full_name varchar2(100), create_date DATE, contents BLOB, CONSTRAINT pk_t_load_4m_sf PRIMARY KEY(id)) lob (contents) store AS securefile; 用于加载LOB数据的控制文件如下: [oracle@dbserver1 sqlldr]$ more sqlldr_4M_sf.ctl LOAD DATA INFILE ‘filename.dat’ INTO TABLE T_LOAD_4M_SF TRUNCATE FIELDS TERMINATED BY ‘,’ (ID … Continue reading

Posted in ORACLE | Tagged , , , | 1 Comment