Tag Archives: partition

数据泵造成的数据损失

客户尝试导入一个分区表的个别几个分区,结果却损失了整个分区表的数据。 下面通过一个例子来在线这个问题: SQL> CREATE TABLE T_PART PARTITION BY RANGE (CREATED) 2 (PARTITION P1 VALUES LESS THAN (TO_DATE(‘2012-1-1’, ‘YYYY-MM-DD’)), 3 PARTITION P2 VALUES LESS THAN (TO_DATE(‘2012-2-1’, ‘YYYY-MM-DD’)), 4 PARTITION P3 VALUES LESS THAN (TO_DATE(‘2012-3-1’, ‘YYYY-MM-DD’)), 5 PARTITION P4 VALUES LESS THAN … Continue reading

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

ORA-600(15214)错误

告警日志中包含ORA-600[15214]错误。 错误信息为: Fri Feb 03 01:21:47 EAT 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_p155_29897.trc: ORA-00600: internal error code, arguments: [15214], [0], [2], [], [], [], [], [] Fri Feb 03 01:21:49 EAT 2012 Trace dumping IS performing id=[cdmp_20120203012149]Fri Feb 03 01:21:47 EAT … Continue reading

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

EXCHANGE分区导致主键重复

分区表的EXCHANGE交换分区不检查数据有效性,可能导致LOCAL主键索引出现重复值。 通过一个简单的例子来说明这个问题: SQL> CREATE TABLE T_PART_EXCHANGE (ID NUMBER, NAME VARCHAR2(30), TYPE VARCHAR2(18)) 2 PARTITION BY LIST (TYPE) 3 (PARTITION P1 VALUES (’TABLE’), 4 PARTITION P2 VALUES (DEFAULT)); TABLE created. SQL> CREATE INDEX IND_PART_EXCHANGE_TYPEID ON T_PART_EXCHANGE(TYPE, ID) LOCAL; INDEX created. SQL> … Continue reading

Posted in ORACLE | Tagged , , | Leave a comment