Re: Error "max extend table reached"

Hello Gerald,

  Looks like you have a problem on your hands.

   As a first step - see if you get DBA to help you.

   If not, and if you have access to the database server:

1. log in as system/sys user (sqlplus "/ as sysdba") and type "show parameter dest".
2. Note value for "background_dump_dest".
3. Go to the background_dump_dest directory and check altert*.log file - you'll find name of the table there along with the all other serious errors
4. make sure this table has big extent size and max_extents (select next_extent, pct_increase, max_extents from dba_tables where table_name = '<bad_table>')
5. Alter max_extents: Example: alter <table> storage ( maxextents 1024 next 10M )

Regards,

   Support
   DBA Infopower LLC
   http://www.dbainfopower.com

The advice provided by DBA Infopower are provided "as is" with no warranty. DBA Infopower expressly disclaims any warranty, regarding the advice including any implied warranty of merchant fitness for a particular purpose aviating course of dealing and/or performance. DBA Infopower does not warrant that the advices provided by DBA Infopower will be free from bias, detests, errors, eavesdropping or listening. DBA Infopower shall not be responsible for the quality of information or the authentication of the services or details given by experts on the advice. By using this advice the user of the advice accepts the terms and conditions of this statement.

"Gerard Farrās" <gerard.farras_at_ctfc.es> wrote in message news:bvop6r$9ct$1_at_news.ya.com...
> Hi all,
>
> I'm a newbie with Oracle database server, and now I having some
> problems.
> I'm working with an application who connects to this database, but I get
an
> error because "a max num of extends for this table is reached". How I can
> solve this problem?
>
> Can anybody recommend me any manual or tutorial for start with Oracle?
>
> Thanks,
>
> --
> Gerard Farrās
> Ārea de Sistemes del CTFC
>
>
Received on Fri Feb 06 2004 - 03:21:40 CST