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
498 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
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 10

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Is this bug still active in RHEL 2 29
sql for Oracle views 8 37
Linux Scripting 3 53
Changing passwords in Linux Systems 3 18
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
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.

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now