oracle 精确到小数秒的timestamp类型分区表

CREATE TABLE TEST_CARD(ID NUMBER(19) NOT NULL,CREATEDATE   TIMESTAMP(6))  2  PARTITION BY RANGE (CREATEDATE)(PARTITION P201104 VALUES LESS THAN (TIMESTAMP' 2011-04-01 14:30:30.3333'),PARTITION P201207 VALUES LESS THAN (TIMESTAMP' 2012-07-01 00:00:00'),PARTITION PMAX VALUES LESS THAN (MAXVALUE));Table created.SQL> insert into test_card values(1,to_timestamp('2011-04-01 14:30:30.3000','yyyy-mm-dd hh24:mi:ss:ff'));1 row created.SQL> select * from test_card partition(p201104);    ID CREATEDATE---------- ---------------------------------------------------------------------------     1 01-APR-11 02.30.30.300000 PMSQL> insert into test_card values(1,to_timestamp('2011-04-01 14:30:30.4000','yyyy-mm-dd hh24:mi:ss:ff'));1 row created.SQL> select * from test_card partition(p201104);    ID CREATEDATE---------- ---------------------------------------------------------------------------     1 01-APR-11 02.30.30.300000 PMSQL> select * from test_card partition(p201107);select * from test_card partition(p201107)                                  *ERROR at line 1:ORA-02149: Specified partition does not existSQL> select * from test_card partition(p201207);    ID CREATEDATE---------- ---------------------------------------------------------------------------     1 01-APR-11 02.30.30.400000 PM