Re: Error "max extend table reached"

Gerard Farrās wrote:

> 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,

Go to http://tahiti.oracle.com and look up "ALTER TABLE".

But depending on your Oracle version, you don't say, and the type of tablespace, dictionary or LMT, I'd take a serious look at dba_tablespaces, dba_free_space, and dba_segments to see what's going on.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)