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

Thread: ORA-01536 space quota exceeded for tablespace 'string'??!!

Hybrid View

  1. #1
    Join Date
    Nov 2003
    Location
    Saudi Arabia
    Posts
    25

    ORA-01536 space quota exceeded for tablespace 'string'??!!

    Tried to create table in one schema from a table in another schema

    SQL> create table orders as select * from hr.orders;
    AND GOT THE FOLLWOING ERROR

    ORA-01536 space quota exceeded for tablespace 'string'

    AND I HAVE NOT SPECIFIED ANY QUOTA FOR THE USER SO WHAT COULD BE THE PROBLME AND HOW TO FIX IT


    THANKS.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    That is the problem: you have to specify quota on the tablespace for the user(s):

    logon as user with alter user privilege (e.g. SYSTEM) and specify quota:

    alter user hr quota 10M on users;
    or:
    alter user hr quota unlimited on users;

  3. #3
    Join Date
    Nov 2003
    Location
    Saudi Arabia
    Posts
    25
    Thanks akkerend
    i'v done it and it worked , but previously i was not specifiying any quotas for the users and it was working fine !!

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    A user doesn't need quota on a tablespace if the user has the UNLIMITED TABLESPACE privilege. This privilege is granted to a user if you grant the RESOURCE role to the user.

  5. #5
    Join Date
    Nov 2003
    Location
    Saudi Arabia
    Posts
    25
    Thanks

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