Teradata: How to add range partition to non empty table?
<p>I have such table:</p>

<pre><code>CREATE SET TABLE ONLINE_BANKING.TRANSACTIONS ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      transaction_id INTEGER NOT NULL,
      date_of_transaction DATE FORMAT 'YYYYMMDD' NOT NULL,
      amount_of_transaction DECIMAL(38,2) NOT NULL,
      transaction_type_code BYTEINT NOT NULL DEFAULT 25 , 
UNIQUE PRIMARY INDEX ( transaction_id );
</code></pre>

<p>I would like to add partition to my filled with data table to date_of_transaction  column. </p>

<p>I tried this way:</p>

<pre><code>ALTER TABLE TRANSACTIONS
MODIFY PRIMARY INDEX (date_of_transaction) -- tried to write different columns, but failed
ADD RANGE BETWEEN DATE '1998-01-01' AND DATE '2015-12-31' EACH INTERVAL '1' MONTH;
</code></pre>

<p>However Teradata returned error:</p>

<blockquote>
  <p>DROP RANGE/ADD RANGE clause no corresponding level that is a RANGE_N function</p>
</blockquote>

<p>What does it mean and what how can I achieve the goal?</p>