title: oracle error while adding column to a table in database (error: 00604)
body: <p>I'm getting this error while trying to add a new column to a table:</p>
  
  <pre><code>ALTER TABLE TBLCOMPANY ADD EVENTCATEGORYLEVEL NUMBER (20) DEFAULT 1
  Error report:
  SQL Error: ORA-00604: error occurred at recursive SQL level 1
  ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
  00604. 00000 -  "error occurred at recursive SQL level %s"
  *Cause:    An error occurred while processing a recursive SQL statement
             (a statement applying to internal dictionary tables).
  *Action:   If the situation described in the next error on the stack
             can be corrected, do so; otherwise contact Oracle Support.
  </code></pre>
  
  <p>I have no idea why it's happening. I tried to google for it, but it seems that nobody has the answer for that. (the action that the db suggests is ridiculous).</p>