Home » SQL & PL/SQL » SQL & PL/SQL » PARTITION BY RANGE.. HELP!!
PARTITION BY RANGE.. HELP!! [message #18418] Wed, 30 January 2002 09:46 Go to next message
CATHYBEE
Messages: 20
Registered: January 2002
Junior Member
EXPERTS: HELP ME PLEASE!

I am trying to add a partition on the primary key in my existing table.

HostKey is PRIMARYKEY with DATATYPE(TIMESTAMP)[[supported by Oracle 9i]]

ALTER TABLE tbl_Claims
ADD
PARTITION BY RANGE (HostKey)
(PARTITION D0200201 VALUES LESS THAN(TO_TIMESTAMP(‘01-FEB-2002 00:00:00.0000’,’DD-MON-YYYY HH:MI:SS.FFFF’)),
PARTITION D0200202 VALUES LESS THAN(MAXVALUE))

I am getting the following error:
PARTITION BY RANGE (HostKey)
*
ERROR at line 3:
ORA-00902: invalid datatype
Re: PARTITION BY RANGE.. HELP!! [message #18420 is a reply to message #18418] Wed, 30 January 2002 11:09 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
TIMESTAMP WITH TIME ZONE is, so far I know, not working with partitioning. So if the exact datatype of HostKey is TIMESTAMP WITH TIME ZONE it will not work.

In case your table is not already partitioned it is not possible to add new partition.
Previous Topic: default database
Next Topic: Oracle Max Function
Goto Forum:
  


Current Time: Fri Mar 29 06:26:19 CDT 2024