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
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.
the user exceeds its limit in utilizing the assigned
you may use this:
alter user USERNAME quota unlimited on TABLESPACE_NAME;
alter user USERNAME quota 50m on TABLESPACE_NAME;
Click Here to Expand Forum to Full Width