Re: Error "max extend table reached"

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