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

Thread: ORA-01536 (Space quota exceeded for tablespace "USERS"

  1. #1
    Join Date
    Jun 2002
    Posts
    88
    Hi,

    How to solve the problem

    ORA-01536 (Space quota exceeded for tablespace "USERS")

    Thanks in advance,

    Regards,
    Iyyappan.M

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ORA-01536 space quota exceeded for tablespace 'string'

    Cause: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.

    Action: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner

  3. #3
    Join Date
    Dec 2001
    Posts
    139
    if u don't have sufficient privilleges ask your dba to increase the tablespace quota.

    if u r a privilleged user i.e DBA then u can uz
    and HDD space is not the issue or u can specify the apace u want to allocate instead of UNLIMITED in terms of K/M bytes

    ALTER USER username
    IDENTIFIED BY password
    QUOTA UNLIMITED ON tablespace_name;

    tablespace name should be the users default tablespace
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

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