Implementing partitioning now should not cause you any problems when you migrate to 10g.
Partitioning is usually used on large tables, both to make maintenance easier and to improve performance. If you have the need to perform maintenance on part of a table, even though it is relatively small, partitioning may make sense then, too.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.