MIKE YOU ARE RIGHT! NOW, HOW DO I GET AROUND THIS PROBLEM? [message #18423] |
Wed, 30 January 2002 12:16 |
CATHYBEE
Messages: 20 Registered: January 2002
|
Junior Member |
|
|
YOU ARE RIGHT!!
But my question now is how do i get around this problem?? Any ideas would be highly appreciated..
CREATE TABLE tbl_ClaimsHistory (
DepositTime TIMESTAMP (4) WITH TIME ZONE NOT NULL)
3 PARTITION BY RANGE(DepositTime)
4 (PARTITION D0200201
5 VALUES LESS THAN(TO_TIMESTAMP_TZ('01-FEB-2002 00:00:00.0000','DD-MON-YYYY HH:MI:SS.FFFF')),
6 PARTITION D0200202
7 VALUES LESS THAN(TO_TIMESTAMP_TZ('01-MAR-2002 00:00:00.0000','DD-MON-YYYY HH:MI:SS.FFFF')),
8* PARTITION D0200203 VALUES LESS THAN(MAXVALUE))
SQL> /
PARTITION BY RANGE(DepositTime)
*
ERROR at line 3:
ORA-03001: unimplemented feature
|
|
|
an example [message #18433 is a reply to message #18423] |
Thu, 31 January 2002 00:51 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
SQL> CREATE TABLE tbl_ClaimsHistory (
2 DepositTime TIMESTAMP (4) NOT NULL)
3 PARTITION BY RANGE(DepositTime)
4 (PARTITION D0200201
5 VALUES LESS THAN(TO_date('01-FEB-2002','DD-MON-YYYY')),
6 PARTITION D0200202
7 VALUES LESS THAN(TO_date('01-MAR-2002','DD-MON-YYYY')),
8 PARTITION D0200203 VALUES LESS THAN(MAXVALUE));
Table created.
SQL> insert into tbl_ClaimsHistory values( TO_TIMESTAMP ('1999-12-01 11:00:00.0001', 'YYYY-MM-DD HH:MI:SS.FF'));
1 row created.
SQL> insert into tbl_ClaimsHistory values( TO_TIMESTAMP ('1999-12-01 11:00:00.1', 'YYYY-MM-DD HH:MI:SS.FF'));
1 row created.
SQL> insert into tbl_ClaimsHistory values( TO_TIMESTAMP ('1999-12-01 11:00:00.20001', 'YYYY-MM-DD HH:MI:SS.FF'));
1 row created.
SQL> select * from tbl_ClaimsHistory ;
DEPOSITTIME
---------------------------------------------------------------------------
01-DEC-99 11.00.00.0001 AM
01-DEC-99 11.00.00.1000 AM
01-DEC-99 11.00.00.2000 AM
Hope that this helps.
Mike
|
|
|
|