Hi,

I have a tablespace TBS_SML which have still 500M available and unlimited
quota but I get error like this:

Exception: ORA-01536 space quota executed for tablespace TBS_SML

I try to add another datafile to this tablespace but still the same problem.
Finally I did export & import all the schema's then it's fixed BUT I don't
know what's the reason for this error is it kind of bug.

I am running oracle 9.1.0.0 on sun Solaris 2.8

Thanks for your help

Hamid Alavi

Office       : 818-737-0526
Cell phone : 818-416-5095

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------