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

[Abubakr]

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.

[akkerend]

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;

[Abubakr]

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

[akkerend]

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.

[Abubakr]

Thanks