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

Thread: ORA-01536 error

  1. 06-03-2003, 04:16 PM #1
    vr76413
    vr76413 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    284

    ORA-01536 error

    Hello all..

    we have multiple users trying to insert data into Oracle 9.2 DB.
    All users are assigned 'USERS' TBS as their Default TBS.

    one user cannot load some data into one table. its giving him,
    "ORA-01536 Space Quota Exceeded for Tablespace " USERS""

    any ideas ?...

    these are locally managed TBS and under Auto allocation.

    Thanks
    ron
    Reply With Quote Reply With Quote
  2. 06-03-2003, 04:30 PM #2
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    That means the user who is getting this error just does not have enough 'quota' on USERS Tablespace. Assign him enough/proper Quota on User Tablespace to resolve this error. Refer to Table USER_TS_QUOTAS.

    HTH.
    -- Dilip
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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