Re: ORA-01536

Hamid,

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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03/31/2004 12:17 PM
Please respond to oracle-l

 
        To:     oracle-l@xxxxxxxxxxxxx
        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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: