title: ORA-01950: no privileges on tablespace 'USERS' as the quota is on another table
body: <p>I'm currently getting a <code>ORA-01950: no privileges on tablespace 'USERS'</code> as my quota is on another table. </p>
  
  <p>I've executed the query:</p>
  
  <pre><code>SELECT * FROM USER_TS_QUOTAS;
  </code></pre>
  
  <p>I've got the following results:</p>
  
  <pre><code>TABLESPACE_NAME | BYTES | MAX_BYTES | MAX_BLOCKS | DROPPED
        DATA           0         -1          0          NO
  </code></pre>
  
  <p>My user has an unlimited quota however when executing an insert I'm unable to do this as it's looking at the USERS table. Any way to fix this?</p>
  
  <p>UPDATE:</p>
  
  <p>The default tablespace was users. The query below confirmed this. </p>
  
  <pre><code>SELECT PROPERTY_VALUE
  FROM DATABASE_PROPERTIES
  WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE';
  </code></pre>
  
  <p>The solution to this problem is to change the tablespace to where I have the quota. Thanks to Alex Poole. </p>