Re: ORA-01562 & ORA-01547 ERRORS

In <4rrtvh$paj_at_news.ios.com>, rxrgroup_at_mail.idt.net (Mike Stenzler) writes:
>new to oracle dba duties....
>
>while attempting a global delete of approx. 107,000 rows from a table
>I keep encountering the errors listed in the subject line.
>
>01562 hints that there may be a databse space problem
>01547 is not in my server error message reference!
>
>I was able to perform my delete by changing the where clause &
>deleteing smaller (much!) groups of rows at a time.
>
>Any ideas? If you need more detailed info let me know.
>
>TIA - mike
>
>mstenzler_at_rxr.com
>rxrgroup_at_mail.idt.net
>

1562, 00000, "failed to extend rollback segment number %s"

/ *Cause: Failure occurred when trying to extend rollback segment
/ *Action: This is normally followed by another error message that caused
/         the failure. Shutdown, restart and then take appropriate action for
/         the error the caused the failure. If starting up the system
/         again doesn't solve the problem, it is possible that there is
/         an active transaction in the rollback segment and the system
/         can't roll it back for some reasons. Check the trace file
/         generated by the PMON process for more information.

This means you may need to increase your rbs tablespace size - or lessen the rollback information as you have done with the where clause.

ora-1547 has magically vanished from my 7.3 manuals as well !!

Bye,
Steve

| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------