DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: space quota exceeded for tablespace system

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    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!


  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    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

  4. #4
    Join Date
    Jun 2000
    Posts
    315
    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.


  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  6. #6
    Join Date
    Jun 2000
    Posts
    315
    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
  •  


Click Here to Expand Forum to Full Width