Most articles and papers on Oracle say that Oracle partitioning has many advantages. However, there are some drawbacks that don’t seem to get much press. Experience has indicated that Oracle partitioning generally works well, but certain conditions highlight specific circumstances in which it’s not always the best option – especially on small databases. Partitioning is mainly targeted toward large database environments. Writer Bio
