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
Printable View
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
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
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;