hi all,
I am trying to create an index and I got the following error:
ORA-01536: sapce quota exceed for tablespace TEST
I look into the tablespace and I got plenty room.
Can someone give me the solutions and explanation please????
Thanks
Printable View
hi all,
I am trying to create an index and I got the following error:
ORA-01536: sapce quota exceed for tablespace TEST
I look into the tablespace and I got plenty room.
Can someone give me the solutions and explanation please????
Thanks
Although there is space, your quota for creating objects on that tablespace is exceeded. Check user_ts_quotas.
Give the foll command
alter user username quota unlimited on tablespace TEST
or create the index by specifying a different tablespace name.
tHANKS VINIT