-
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.
-
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;
-
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 !!
-
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.
-
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
|