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 PM

SQL> 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 PM

SQL> select * from test_card partition(p201107);
select * from test_card partition(p201107)
                                  *
ERROR at line 1:
ORA-02149: Specified partition does not exist


SQL> select * from test_card partition(p201207);

    ID CREATEDATE
---------- ---------------------------------------------------------------------------
     1 01-APR-11 02.30.30.400000 PM