how can you enable partitions in Oracle 10g Enterprise Edition for Windows?

Question

I installed Oracle 10g Enterprise Editions onto Windows XP. It appeared that Partitions were installed as part of the default install, however the partitions functionality is not enabled. I can find instructions for enabling partitions on Unix/Linux, but not Windows. Has anybody had any success enabling partitions in 10g EE on their local machine?

thanks Tim

Answer 1

SELECT * FROM V$OPTION WHERE PARAMETER = 'Partitioning';

will answer the question as to whether or not partition has truly been installed.

What's it return?