Partitions and Subpartitions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Partitions and Subpartitions

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Partitions and Subpartitions

    I have a table that will have four months of data that I want to partition. The key will be the number 1 through 4 and then we want to break it down by week in each partition 1 through 5.

    What would be the best type of partition for this? We want to make sure we can do an online backup of each partition. Database is 9.2.0.3.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    range or list

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Why are you using numbers instead of meaningful dates for this?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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