RE: Max Extents Error

This
is very simple. just follow the oracle instruction; increase the maxextents of the table.
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>3101631, 00000, "max # extents (%s) reached in table %s.%s"// *Cause:  A table tried to extend past maxextents// *Action: If maxextents is less than the system maximum, raise it. Otherwise,//          you must
recreate with larger initial, next or pctincrease params <FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Joan

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Sanjay KumarSent:   Thursday, March 08, 2001 2:01 PMTo: Multiple recipients of list   ORACLE-LSubject: Max Extents Error
  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:41:24 CST