title: Alter Table - add Default value for a COLUMN type BLOB
body: <p>Executing the below SQL is giving this error .</p>
  
  <pre><code>alter table TABLE_NAME ADD FILE_DATA BLOB NULL default 'EMPTY_BLOB()'
  </code></pre>
  
  <blockquote>
    <p>Error starting at line 37 in command: alter table TABLE_NAME ADD
    FILE_DATA BLOB NULL default 'EMPTY_BLOB()' Error report: SQL Error:
    ORA-30649: missing DIRECTORY keyword
    30649.0000 -  "missing DIRECTORY keyword"<br>
    *Cause:    DEFAULT DIRECTORY clause missing or incorrect.<br>
    *Action:   Provide the DEFAULT DIRECTORY.</p>
  </blockquote>
  
  <p>Could someone help me out ? </p>
  
  <p>I can either create a new column of TYPE BLOB , or I can convert the same column created as a VARCHAR with DEFAULT value - and then change the type to BLOB . But I am not able to either of them . </p>