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

Thread: Range Partitioning a Table

  1. 05-24-2006, 02:32 AM #1
    jaingaurav
    jaingaurav is offline Junior Member
    Join Date
    May 2006
    Posts
    17

    Range Partitioning a Table

    Hi Everyone,

    I have to partition a table using range partitioning and the problem is that the column on which I have to partition is not a purely numeric column. It is a mixture of numeric and non numeric values like
    BBIP20003844

    I need to know that is there any way to range partition a table on a column like this.

    Any information would be of great help.

    Thanks in Advance.
    Reply With Quote Reply With Quote
  2. 05-24-2006, 09:52 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    sure, VALUES LESS THAN 'C' will put the data in the "B" partition.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 05-24-2006, 09:53 AM #3
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Of course it is possible, it is just a character string ... whether it is meaningful to do so in your situation is a different matter of course.

    For what purpose are you partitioning the table?
    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