title: How do you add a CLOB column with a separate tablespace to an existing Oracle table?
body: <p>I'm trying to add a CLOB column with a separate tablespace to an existing Oracle table.  The existing table, "articles":</p>
  
  <pre><code>create table articles (
      id           number,
      title        varchar2(100),
      published    timestamp;
  ) tablespace TS_DATA;
  </code></pre>
  
  <p>has no CLOB columns.  I've created a separate tablespace to hold the CLOB data:</p>
  
  <pre><code>create tablespace TS_LOB
      datafile size 1024M autoextend on next 1024M maxsize 32767M;
  </code></pre>
  
  <p>When I try the following to add the CLOB column to "articles" as SYS using:</p>
  
  <pre><code>alter table articles add (content clob)
      lob (content) store as basicfile art_content_seg (tablespace TS_LOB);
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>ORA-01950: no privileges on tablespace 'TS_LOB'
  </code></pre>
  
  <p>There is plenty of space on disk to accommodate the tablespace.</p>
  
  <p><strong>SOLUTION</strong>
  I found the problem.  I needed to issue:</p>
  
  <pre><code>alter user &lt;TABLE OWNER&gt; quota unlimited on TS_LOB;
  </code></pre>
  
  <p>Previously I had issued:</p>
  
  <pre><code>grant unlimited tablespace to &lt;TABLE OWNER&gt;;
  </code></pre>
  
  <p>But that didn't work.</p>