DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Partitioning a Table

  1. #11
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323

    Lightbulb

    Hi

    Thanks Sanjay. It is working.

    Sorry! Previously I have done a mistake that, I tried with only two partitions, one is for Jan and upper partition is for dec. And coolly I was inserting values for Feb. month, obviously records inserted into Dec. partition. I am a fool, How can I expect my records go into Jan month!?

    Sorry for the inconvenience caused.

    Thanks for your attention.


    Nagesh

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I think there is a fundamental flaw in the table design. I may be wrong with the example you gave here.
    An attribute (a substring of an attribute) in a table should not depend upon itself (or rest of the values in the attribute).

    In your case the first 2 characters of session_id is not a good candidate for the partition key.

    Have a one more look on the table design. Atleast your development work will be easy.

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