-
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
-
is your database an upgrade from an eariler version?
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
No. It was just installed for tests from 10.2.0.1.0 distribution (Solaris 9)
-
Do you really need time zone in the partition key?
Tamil
-
i'm not sure about this.
but the column itself need this format because the values stored there are with timezone.
-
Might be time for a synthetic key. Ought to work as long as you assign the key to the time zone values in large batches, but it's not something I've spent a lot of time thinking avbout personally.
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
|