title: Alter table on global temporary table (preserve to delete)
body: <p>Is it possible to change a global temporary table in Oracle from PRESERVE ROWS to DELETE ROWS? </p>
  
  <p>I have tried the following command and I get a syntax error. If it is possible, what is the correct syntax?</p>
  
  <pre><code>ALTER TABLE BLOCKING_RESULTS ON COMMIT DELETE ROWS
  </code></pre>
  
  <blockquote>
    <p>SQL Error: ORA-01735: invalid ALTER TABLE option
    01735. 00000 -  "invalid ALTER TABLE option"</p>
  </blockquote>