Oracle Database Discussions

Hi,

I'm developer, recently, system run for few months get an error ORA-01536: space quota exceeded for tablespace 'USR_D', and I asked the DBA to check whether the tablespace in 'USR_D' is full. But when she checked, the tablespace named 'USR_D' only been used 19%, still have a lot of free space.

My system table all in 'AVS' schema, and this schema have one users named 'AVS' as well, this particular 'AVS' user have the privilege to insert/delete/update/create/alter/drop/...... most of the privilege. So, what should I do?

I review the [http://www.dbasupport.com/forums/showthread.php?t=47410] , but still i don't understand what i should do. Forgive me, that i'm not so sure how tablespace works.

Pls, help.

Thank you.

~ Vincent.