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
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;
alter user hr quota unlimited on users;
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.
Click Here to Expand Forum to Full Width