Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: Oracle Partitions

    Hi,

    I have a very basic question on Oracle partitioning.
    Can the partitions be created while we are gathering (insert/update) the data. My data in column that determines the partitioning is based on the incoming value, for egs: a number that could range from 1-1000.

    Related to the above is there any max limit or optimal value for the number of partitions that can be created on a particular table ?

    I am using oracle 10g.

    Thanks
    _Pete

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://tahiti.oracle.com contains the whole Oracle Doc. set, but you already knew that from read the STICK Post at the top of this forum. Right?
    http://download-west.oracle.com/docs...htm#sthref2577
    Above contains answers to many questions regarding partitions.
    However I doubt that partitions work the way you hope they do; but since I'm not sure what type of partition (range, hash, etc.) you need I could be mistaken.

    HTH & YMMV!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •