partition on timestamp with time zone
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.
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
"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
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
Click Here to Expand Forum to Full Width