title: how to enable partitioning option true after installing the Oracle?
body: <p>I have installed oracle 10G XE but in the time of installation i may have not enabled the partion option.now when i am running the command </p>
  
  <pre><code>select * from v$option where parameter = 'Partitioning'; its showing false ..
  </code></pre>
  
  <p>when i tried to run this script</p>
  
  <pre><code>   CREATE TABLE products
   (partno NUMBER,
    description VARCHAR2 (60))
  PARTITION BY HASH (partno)
  PARTITIONS 4
  STORE IN (tab1, tab2, tab3, tab4);
  </code></pre>
  
  <p>it shows that</p>
  
  <pre><code>ORA-00439: feature not enabled: Partitioning
  </code></pre>
  
  <p>i have important tables there if i delete the database then i will have to face problem.</p>
  
  <p>can i enable portioning option after installing??or i have to re install the oracle??please help.</p>