ORA-01536: space quota exceeded for tablespace
1. TO FIND OUT THE QUOTA FOR A USER ON THAT TABLESPACE
USE FOLLOWING QUERY:-
SELECT *
FROM dba_ts_quotas
WHERE USERNAME='ISLBAS'
AND TABLESPACE_NAME='ISLSYS'
2. Increase the quota for that user by this following command
ALTER USER ISLBAS QUOTA UNLIMITED ON ISLSYS;
OR
==
another cause may happen this error
this cause is :-
your are working on a table which owned by another user
so first need to find out that user. then give the owner user
quota unlimited to the tablespace .
For this :- you have to do
1.
select NAME,TYPE
from dba_dependencies
where REFERENCED_NAME='STFACMAS';
2.
select OWNER,OBJECT_NAME
from dba_objects
where OBJECT_NAME='DBT_STFACMAS_CD_CURBAL';
3.
grant unlimited tablespace to ISLBAS;
Everything Changes
2 weeks ago
No comments:
Post a Comment