Re: Help! failed to extend rollback segment error.

Hi ,

    My rollback segments are keep growing, is there a way to cleanup the rollback segments savely?

Thanks!.

barry_roomberg_at_iacnet.com (Barry Roomberg) writes:

>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.
 

>Sorry, you'll have to add a file.
>Separate out you rollback segments into a tablespace of
>their own. Fragmentation will no longer be an issue.
Received on Wed Nov 22 1995 - 00:00:00 CET