title: Oracle 12c - how to partition existing table?
body: <p>Is it possible to partition existing table in Oracle without creating secondary table? </p>
  
  <p>Or is recommended to create a second table first with all partitions and then copy over everything from a first table?</p>
  
  <p>I have table 't1':</p>
  
  <pre><code>CREATE TABLE t1 (
      id INT NOT NULL,
      accountnumber VARCHAR NOT NULL,
      yr_qtr INT NOT NULL
  )
  </code></pre>
  
  <p>yr_qtr has 15 distinct values. </p>
  
  <p>I want to partition table 't1' based on yr_qtr which is int (or create 't2' with yr_qtr partitions).</p>