Re: max # extents

From: L.M.Gardner <leigh.gardner_at_bigfoot.com>
Date: Fri, 30 Oct 1998 08:21:20 GMT
Message-ID: <3636d81f.3129215@news.globalnet.co.uk>

I >think< that there is a maxium of 121 extents within Oracle - and you dont/cant expand above that - what you do is increase the size of each extent itself - ie. from 1mb extents to 10mb extents, etc.

Anyone else care to clarify my mubblings?

On Tue, 27 Oct 1998 11:03:30 -0800, Veronique Molinari <vmolinar_at_uno.edu> wrote:

>Hi,
>
>My application runs on a Personal Oracle 7.3 for Windows 95 database. I
>got an error message indicating that I should expand the rollback_data
>tablespace. After expanding it, I now get the following error message:
>ORA-01562: failed to extend rollback segment number 3
>ORA-01628: max # extents (121) reached for rollback segment RB2
>Can anyone help me solve this problem?
>
>Thanks in advance.
>
>Veronique
>
Received on Fri Oct 30 1998 - 02:21:20 CST