Re: HELP: 0RA-01631: max # extents (505) reached in table PLNDAD (7.1.6/SCO5)

From: <mpir_at_compuserve.com>
Date: Wed, 10 Jun 1998 13:55:56 GMT
Message-ID: <6lm39c$dmr$1@nnrp1.dejanews.com>

Just modifying initial and next won't help. There is also a max_extents parameter for the tablespace, tables and indexes. The tablespace supplies the default for the table or index if it is not specified at create time. Use the alter command to change them.

Be careful in the the max number of extents in version 7 was a platform specific variable. On some it was 121 extents, on others 250, etc. You can specify whatever you want, but if you go past the platform limit, you can corrupt the database (it happend to me.)

In article <6lljdk$rpf$1_at_goof.de.uu.net>, "KZV - Niedersachsen EDV" <waldtu_at_kzvn.h.uunet.de> wrote:
>
> Hi,
> if you reached max extents on table plndad, you must increase the
> storageparameters for initial and next. Let me say initial 500M and next
> 250M.
>
> Of course 505 extents with 10M is much more then your tablespace.
>
> Hope it helps
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 08:55:56 CDT