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

Thread: Tablespace Quota Problem

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    When I try to create a table I am getting an
    ORA-01536: space quota exceeded error.

    I know the reason of this error. What I am wondering is
    there is no quota set for any tablespace for any user.

    ie. select * from dba_ts_quotas does not return any rows.

    But, I am getting this error frequently. In order to overcome this error I also assigned 'unlimited tablespace' privilege to that user but still it occurs frequently. Every time I have to give this privilege(approx. once in 2hrs).

    OS: Windows 2000
    Db version: Oracle9i.
    Tablespace: Locally Managed Tablespace.

    I feel that I am hitting a bug.

    Any help will be appreciated.

    Thanks.
    Vijay.
    Say No To Plastics

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    No Replies.................
    Say No To Plastics

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Here is what I suggest:

    Run as system:

    Code:
    alter user HIS_NAME quota unlimited on THE_TABLESPACE_NAME;
    If it still does not work, then tell me: Have you revoked any roles? How about the RESOURCE role?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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