-
partition by range on "timestamp with time zone" column
Hi.
On Oracle 10g i'm trying to partition the table by range of "timestamp with time zone" column:
CREATE TABLE ACCT
(
...
ACCTSTOPTIME TIMESTAMP(0) WITH TIME ZONE,
...
)
PARTITION BY RANGE (ACCTSTOPTIME) (
PARTITION ACCT_042005 VALUES LESS THAN (TO_DATE('01052005','DDMMYYYY')),
...
);
but got an error:
PARTITION BY RANGE (ACCTSTOPTIME) (
*
ERROR at line 52:
ORA-03001: unimplemented feature
is it completely impossible to partition the table by this type of date?
Is there any workaround on this?
thanks,
--
Alexander
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|