Tag Archives: TABLE_EXISTS_ACTION

客户尝试导入一个分区表的个别几个分区，结果却损失了整个分区表的数据。 下面通过一个例子来在线这个问题： 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 →