请问现项目中有个分区表中有2个分区如下:
PARTITION EAI_AUDIT_30BD_3_20090812 VALUES LESS THAN (TIMESTAMP'2009-08-12 00:00:00')
PARTITION EAI_AUDIT_30BD_3_20090813 VALUES LESS THAN (TIMESTAMP'2009-08-13 00:00:00')
PARTITION EAI_AUDIT_30BD_3_MAX VALUES LESS THAN (MAXVALUE) 那如果我插入的数据是2009-08-06的话,这部分数据会存放在哪个分区呢?以上三个分区都满足条件的啊!请赐教,在线等!!!多谢!!!
PARTITION EAI_AUDIT_30BD_3_20090812 VALUES LESS THAN (TIMESTAMP'2009-08-12 00:00:00')
PARTITION EAI_AUDIT_30BD_3_20090813 VALUES LESS THAN (TIMESTAMP'2009-08-13 00:00:00')
PARTITION EAI_AUDIT_30BD_3_MAX VALUES LESS THAN (MAXVALUE) 那如果我插入的数据是2009-08-06的话,这部分数据会存放在哪个分区呢?以上三个分区都满足条件的啊!请赐教,在线等!!!多谢!!!
http://www.inthirties.com/?p=543
这个分区!
你用的是个范围分区!
如果你还想加分区:只有split了,不能用add