DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: partition on timestamp with time zone

  1. #1
    Join Date
    Jun 2000
    Posts
    295

    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,

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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?

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    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.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
  •  


Click Here to Expand Forum to Full Width