ORA-01536

[hummy]

can anyone tell me what the following error message means and how to resolve it

ORA-01536 space quota exceeded for tablespace "spcp_data".

I Think I know how to solve but would like some clarification

Thanks

[hrishy]

Hello

What this means is that the user has exceeded his space quota on table space spcp_data (maybe he was adding a new segment or the existing segments tried to acquire a new extent ) ask your dba to increase the users quota on that tablespace.

regards
hrishy

[reydp]

the user exceeds its limit in utilizing the assigned
tablespace.

you may use this:

alter user USERNAME quota unlimited on TABLESPACE_NAME;

or

alter user USERNAME quota 50m on TABLESPACE_NAME;