Thread: Oracle Partitions
06-04-07, 20:48 #1Registered User
- Join Date
- Jun 2007
Unanswered: Oracle Partitions
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.
06-04-07, 21:40 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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?
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.