Re: Help with Rollback Segment Cannot be Extended workaround.

Anon wrote:

> I have a large script to run that updates data in many rows. I get
> the error that the rollback segment cannot be exteneded.
> Does anyone know how to get around this?
> Is there a way to have the changes comitted automatically so no
> rollback segment is needed?
>
> The easy way would be to make the rollback segments auto-extend to an
> unlimited size. I am at a customers site and making changes to the
> production system is very difficult and I only need it for this one
> operation.
> Oracle seems to be running OK with no problems. I just need to make
> this one-time data conversion and I will be finished. I am curently
> running the script from Sql Plus and the database is Oracle 8.0.5.
>
> Don

There is no way to get around rollback segments. And for that I am grateful. But what I would interpret it to mean is that you either need to commit more frequently or your rollback segments are woefully inadequate and need to be dropped and recreated large enough to handle the transactions, or the rollback tablespace is too small and the rollback segment has no room into which to expand.

(this situation will not change with a current version of Oracle or with 9i).

Daniel A. Morgan Received on Thu May 17 2001 - 20:41:10 CDT