Max Extents Error
Hi, I have a table which consists of Long Raw column in addition to other columnsof 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
Re: Max Extents Error
Check the maxextents value assigned to the table: select max_extents from dba_tables where table_name = 'your_table_name'; Next, see how many extents the table is actually using: select count(*) from dba_extents where table_name = 'your_table_name'; I'll bet the numbers are equal. If so: Alter your_table_name storage(maxextents 999); where 999 is equal to a number larger than that obtained in the earlier scripts._ [EMAIL PROTECTED] 03/08/01 02:00PM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Max Extents Error
Hi Sanjay, Issue this command as the table owner: alter table A maxextents unlimited; Check the max extents for the table and use an appropriate value for your application. Unlimited will allow the table to grow to the size of free space in the tablespace. HTH, Rocky --- Sanjay Kumar [EMAIL PROTECTED] wrote: 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 __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Max Extents Error
Title: RE: Max Extents Error -Original Message- From: Sanjay Kumar [mailto:[EMAIL PROTECTED]] Sent: jeudi, 8. mars 2001 11:01 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. Check the max_extents for the table: select extents, max_extents from dba_segments where owner = 'table_owner_name' and segment_name = 'table_name' and segment_type = 'TABLE' ; You will have to change the max_extents on the table with the SQL command alter table, e.g. alter table owner.name storage (maxextents new_value) ; But before you do so, you may want to ask yourself - is there a reason that the current maxextents value was chosen? Should some rows from the table be archived deleted? Of course, since this is a development environment perhaps it's not as important to know the answers to those questions. -- any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: Max Extents Error
Also you can resolve by , Alter table_name storage(maxextents unlimited); -Original Message- Sent: Thursday, March 08, 2001 11:49 AM To: Multiple recipients of list ORACLE-L Pardon my syntax. Tim's is correct. --- Tim Sawmiller [EMAIL PROTECTED] wrote: Check the maxextents value assigned to the table: select max_extents from dba_tables where table_name = 'your_table_name'; Next, see how many extents the table is actually using: select count(*) from dba_extents where table_name = 'your_table_name'; I'll bet the numbers are equal. If so: Alter your_table_name storage(maxextents 999); where 999 is equal to a number larger than that obtained in the earlier scripts._ [EMAIL PROTECTED] 03/08/01 02:00PM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).