-
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:
insert into
tpub.sgml_proc
(
sgml_proc_id,
proc_title_id,
content_id,
lan
)
select
'n306802',
'3963',
'170083',
lan
from
tpub.language_codes
/
tpub.sgml_proc
*
ERROR at line 2:
ORA-01536: space quota exceeded for tablespace 'SYSTEM'
Thank you!
-
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
user.
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....
-John
John Dorlon
www.ezsql.net
john@ezsql.net
-
I would run this query just to check all your users.
select username, default_tablespace, temporary_tablespace
from dba_users
order by 2
I would also be more careful in the future when creating tables.
MH
-
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:
Code:
select owner, segment_name, tablespace_name
from dba_segments
where owner = 'TPUB'
and segment_name = 'SGML_PROC'
Jeff Hunter
-
Thank you!
Problem is resource role somehow got screwd up!
Lisa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|