ORA-01950: no privileges on tablespace 'USERS' as the quota is on another table
<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>