Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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:08:17 CST