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
oracle 精确到小数秒的timestamp类型分区表
最新推荐文章于 2022-02-07 01:37:02 发布