-
partition on timestamp with time zone
Hi,
Does not Oracle allow partition on
timestamp with time zone column?
CREATE TABLE test2 ( created timestamp with time zone)
PARTITION BY RANGE (created) ( PARTITION p_others VALUES LESS THAN (MAXVALUE));
ERROR at line 2:
ORA-03001: unimplemented feature
Partition on date or timestamp is OK.
Thanks,
-
Restriction on Partitioning Key Columns
The columns in the column list can be of any built-in datatype except ROWID, LONG, LOB, or TIMESTAMP WITH TIME ZONE.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
I'm wondering what would be the impact of data moving across time zones (e.g. replication) if this were possible. Would it imply migration of rows between partitions?
-
Does anyone know why "TIMESTAMP WITH TIME ZONE" column cannot
be partitioned?
Is this a bug or feature?
PS: Oracle 10g does support this either.
-
its not a bug its intentional, by the fact its documented and you get a sensible error message.
See dapi's point for the dilemna
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
|