Re: Help! failed to extend rollback segment error.

Stancu Victor <stancu_at_bnr.ca> wrote:

>Hi, all.
>Can anyone help me with an annoying Oracle error that use to occurs
>every time my tables are growing too much ? The error is :
>ORA-01562: failed to extend rollback segment (id = 6), and then ...
>ORA-01547: failed to allocate extent of size 2.
>Has anyone a global solution to avoid this in the future, without adding
>and adding new files ? I did that before, as recommended in Oracle
>manuals, but the database fragmentation is another major danger.
>Professional help will be appreciated.
>Thanks in advance, Victor.
>
>
Victor,

The only way round this problem is to do some sizing exercises before you create your tablespaces. There are quite a number of storage parameters that can be set. A good read is the Oracle Press DBA Handbook. Received on Sun Nov 12 1995 - 00:00:00 CET