Keep getting ORA-12008, ORA-01536 and ORA-06512 errors when script attempt to load data in table
Posted on 2015-02-06
There is a script that ingests data into the database. When that script is executed I get the following error message:
ORA-12008: error in materialized view refresh path
ORA-01536: space quota exceeded for tablespace 'USERS'
ORA-06512: at "SyS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SyS.DBMS_SNAPSHOT", line 276
ORA-06512: at "SyS.DBMS_SNAPSHOT", line 2745
ORA-06512: at line 1
The database user has unlimited quota on the tablespace. There is plenty of space available to write to the tablespace. I can't find anything else that could be the problem.