DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002

    How to solve the problem

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

    Thanks in advance,


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    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
    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.