<div>
You have to add tablespace to USERS.
</div>


<div>
I granted resource to the user and now it works
</div>


I granted resource to the user and now it works

<div>
<div class="content wysiwyg-content">
There is a script that ingests data into the database. When that script is executed I get the following error message:<br />
<br />
ORA-12008: error in materialized view refresh path<br />
ORA-01536: space quota exceeded for tablespace 'USERS'<br />
ORA-06512: at &quot;SyS.DBMS_SNAPSHOT&quot;, line 2563<br />
ORA-06512: at &quot;SyS.DBMS_SNAPSHOT&quot;, line 276<br />
ORA-06512: at &quot;SyS.DBMS_SNAPSHOT&quot;, line 2745<br />
ORA-06512: at line 1 <br />
<br />
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.
</div>
</div>


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.

Keep getting ORA-12008, ORA-01536 and ORA-06512 errors when script attempt to load data in table

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Virtualization is the act of creating a virtual (rather than actual) version of something, including (but not limited to) a virtual computer hardware platform, operating system (OS), storage device, or computer network resources. Virtualization is usually the creation of a system that executes separate from the underlying hardware resources, or the creation of an entire desktop for systems located elsewhere, similar to thin clients.