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

Thread: Partitions and Subpartitions

  1. 03-13-2006, 11:08 AM #1
    lesstjm
    lesstjm is offline Advisor
    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
    Reply With Quote Reply With Quote
  2. 03-13-2006, 11:19 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    range or list
    Reply With Quote Reply With Quote
  3. 03-13-2006, 12:47 PM #3
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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