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

Thread: Problem

  1. 03-28-2001, 09:06 AM #1
    Enrico
    Enrico is offline Junior Member
    Join Date
    Mar 2001
    Posts
    1
    Hello,

    I have this error message when I try to insert 3000 rows to table. It appears on th 500° row.
    ORA-01536 : space quota exceeded for tablespace USR

    I tried to increase the tablespace but I have tuhe same Error.

    If someone can help me...

    Thanks.
    Reply With Quote Reply With Quote
  2. 03-28-2001, 09:17 AM #2
    aracnid
    aracnid is offline Member
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    The consistent block of the next extent (of your table) prob. is higher than the max free block of your tablespace...so check the storage of your table (the next extent)
    Reply With Quote Reply With Quote
  3. 03-28-2001, 09:19 AM #3
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Check for the quota of the user who is trying to insert the data. If its limited change it to the appropriate value.
    Reddy,Sam
    Reply With Quote Reply With Quote
  4. 03-28-2001, 09:24 AM #4
    tomate
    tomate is offline Member
    Join Date
    Mar 2001
    Posts
    188

    Increase the quota for this user

    the user had reached the limit of its quota.
    Speak with your administrator to increase this quota or he must be insert the large raws

    Thomas Schmidt
    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