Pages

Tuesday, September 3, 2013

ORA-01536: space quota exceeded for tablespace xyz

Today I had this error:

ORA-01536: space quota exceeded for tablespace

So it seems that my user couldn't write to his default tablespace. So deceided to check my user:

SQL> select tablespace_name, username, bytes, max_bytes from dba_ts_quotas where username like '%KAREL%';
no rows selected