-
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.
-
sure, VALUES LESS THAN 'C' will put the data in the "B" partition.
Jeff Hunter
-
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?
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
|