Solved

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

Posted on 2015-02-06
3
555 Views
Last Modified: 2015-02-19
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.
0
Comment
Question by:sikyala
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 13

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 500 total points
ID: 40594447
Taken from http://portrix-systems.de/blog/mjendrossek/fun-with-tablespace-quotas-and-dba/
So, by revoking dba, oracle implicitly also revokes any tablespace quotas for that user.

edit:
Same goes for role “resource”.
This is actually documented behaviour. See Metalink Note 465737.1 “ORA-01536 After Revoking DBA Role”:

Maybe also helpful: https://community.oracle.com/thread/2339319
0
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 40594915
You have to add tablespace to USERS.
0
 

Author Closing Comment

by:sikyala
ID: 40619289
I granted resource to the user and now it works
0

Featured Post

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question