Results 1 to 2 of 2

Thread: list partition

  1. #1
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18

    Unanswered: list partition

    Hi,
    I have a history table with a column date in it but I want to partition that table by month. How can I list partition it by month so that it contains data
    for each month for every year?
    Thanks for your help
    lucy

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Only thing that comes to mind is to create a column that is defaulted to to_char(<date column>, 'Mon' ). Then create partitions for 'Jan', 'Feb', etc. Problem comes from the fact that you cannot create a partition based on a function, which would be very useful in this type of table def. However, would recommend a HASH partition to evenly distribute the data.
    JoeB
    save disk space, use smaller fonts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •