How come user get ora_1536: space quota exceeded for tablespace 'SYSTEM', though I never give them quota on system tablespace. The following is the query:
ERROR at line 2:
ORA-01536: space quota exceeded for tablespace 'SYSTEM'
Your tpub.sgml_proc table is in the SYSTEM tablespace.
You are getting the error because the table needs to extend
and there is no quota in the SYSTEM tablespace for that
You should move that table - and any other table you have
created - out of the SYSTEM tablespace and grant whatever
quotas are needed on the other tablespaces....
I would run this query just to check all your users.
select username, default_tablespace, temporary_tablespace
order by 2
I would also be more careful in the future when creating tables.
It's not so easy. User tpub's default tablespace is tpubdata, and has no quota on system tablespace.
Table sgml_proc is in tablespace tpubdata.
to verify , run this query:
select owner, segment_name, tablespace_name
where owner = 'TPUB'
and segment_name = 'SGML_PROC'
Problem is resource role somehow got screwd up!
Click Here to Expand Forum to Full Width