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

Thread: ora-01536

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    2

    Thumbs down

    hello!!

    i'm getting an error
    0ra-01536(space quota exceeded for tablespace 'string')

    for this i hav dropped unnecessary objects in my tablespace.
    i'm asked to increase the quota on this tablespace for the segment owner.
    can someone please tell me how to increase the quota on this tablespace for the segment owner.

    it is urgent. please help me.



  2. #2
    Join Date
    Jul 2000
    Posts
    243
    Hi

    "ALTER USER user_name QUOTA number [K/M] ON tablespace name"
    or run this:
    "ALTER USER user_name QUOTA UNLIMITED ON tablespace name"

    also, only the owner of the tablespace or a privileged user must grant additional resource quota on the tablespace to the user.

    hope this helps


  3. #3
    Join Date
    Jun 2001
    Posts
    2
    hi!! shawish_sababa,

    Thank you for ur timely help.Problem been resolved.




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