PITSS.CON Error – Insert…ORA-01536: space quota exceeded for tablespace

May 6, 2015

It is recommended that all PITSS.CON users have an unlimited quota to the tablespace which each PITSS.CON belongs to. If any of the PITSS.CON users do not have an unlimited quota to the tablespace, the following error could be presented:

Insert…ORA-01536: space quota exceeded for tablespace…

https://pitss.com/files/2015/05/image.png

To fix this, all PITSS.CON users including the MIG user should have the following database privileges granted:

  • grant UNLIMITED TABLESPACE to USER;
  • grant user USER quota unlimited on PITSS_TABLESPACE;

After applying one of the grants above on each PITSS.CON user (including MIG), the error should disappear.

Source: Oracle Support note 1084014.6