you need to increase quota for the user on that tablespace;
alter user <username> quota <size>K|M|UNLIMITED on <tablespace_name>
Regards,
Juriy Matey
Hamid Alavi <hamid.alavi@quovadx.com> Sent by: oracle-l-bounce@freelists.org
03/31/2004 12:17 PM
Please respond to oracle-l
To: oracle-l@freelists.org
cc:
Subject: ORA-01536
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@freelists.org
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
-----------------------------------------------------------------
