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

    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.

    Say No To Plastics

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

  3. #3
    Join Date
    Jun 2001
    Helsinki. Finland
    Here is what I suggest:

    Run as system:

    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

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