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

If setting the parameters as high as mentioned here, remember to lower the next_extent setting after loading the table, or you will run out of tablespace soner or later.....

Might be an open door, but I thought I just mention it. --
Roald

R.A. van Geleuken
r.vangeleuken_at_syntegra.nl

KZV - Niedersachsen EDV <waldtu_at_kzvn.h.uunet.de> wrote in article <6lljdk$rpf$1_at_goof.de.uu.net>...
> 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
>
>
>
>
>
Received on Wed Jun 10 1998 - 09:42:13 CDT