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;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 … Continue reading

Posted in ORACLE | Tagged , , , | 1 Comment