Monday, August 23, 2010

Ora-01536 space quota exceed

I am facing problem of ora-01536 problem.

The error says that ORA-01536:
space quota exceed for tablespace 'TBS_AC_INDX' but it has 100 MB space and only using 3 MB.

What is the problem.

Answer
Hello,

Though I am not an expert in this area, I would advise you to try this out

ALTER USER username QUOTA UNLIMITED on TBS_AC_INDX;

(where username is your schema name which is using this tablespace)

Hope this helps you.

No comments: