Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Max Extents Error

Max Extents Error

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Thu, 08 Mar 2001 11:08:17 -0800
Message-ID: <F001.002C7791.20010308110059@fatcity.com>

Hi,
 

I have a table which consists of Long Raw column in addition to other columns of Number and Varchar2 datatypes.
 

I have the datafile size set to 2GB. The average length of the messages goes up to 100M, sometimes more than that.
 

I have now added three datafiles to that tablespace each greater than the first datafile. But I still keep getting the ORA-01631 Max extents reached for table "A" error.
 

What do I do resolve this error?
 

I am using 8K as the DB block size on SOlaris with Oracle 816. It is not a prod environment instead a dev environment.
 

Thanks
Sanjay Received on Thu Mar 08 2001 - 13:08:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US