Help! failed to extend rollback segment error.
From: Stancu Victor <stancu_at_bnr.ca>
Date: 1995/11/10
Message-ID: <480ato$kc9_at_bcarh8ab.bnr.ca>#1/1
Date: 1995/11/10
Message-ID: <480ato$kc9_at_bcarh8ab.bnr.ca>#1/1
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.
Received on Fri Nov 10 1995 - 00:00:00 CET