Re: Error "max extend table reached"

Dear Sybrand,

   If you had a chance to visit our site you'll find out that we do not sell tools to defragment tablespaces.

   if DBA is using same size extents across the tablespace objects then there is no need for such a tool.

   In previous case our goal was to help user to restore services as soon as possible. SQL provided was an example. not a recommendation to run in production.

Regards,

Support

DBA Infopower

https://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.

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:hev620hf2ts69dadh6eof5d77isrk5htuj_at_4ax.com...
> On Fri, 6 Feb 2004 01:21:40 -0800, "DBA Infopower Support"
> <support_at_dbainfopower.com> wrote:
>
> > 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 )
>
> Unprofessional advice that will likely get the OP in more trouble.
> Have you ever heard of tablespace fragmentation, or are you selling a
> product to repair the problems caused by this advice?
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 06 2004 - 12:37:01 CST