Re: Rollback segment problem

Increase the size of the 'NEXT EXTENT' on the rollback segment...

alter rollback segment R0? storage(next ....);

Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK> wrote in article <5nv8v9$732$1_at_power42t.hkbu.edu.hk>...
> -----BEGIN PGP SIGNED MESSAGE-----
>
> =======================Error Message============================
> ORA-01562: failed to extend rollback segment number 4
> ORA-01628: max # extents (121) reached for rollback segment R03
> ORA-06512: at line 1
> =======================End of Message===========================
>
> There are 3-4 rollback segment R0? It happens to each RBS.
> How to fix this problem? Please reply to wschow_at_comp.hkbu.edu.hk
> Thanks in advance.
>
> - --
> PGP PUBLIC KEY: https://www.comp.hkbu.edu.hk/~wschow/pgp.html
> Key fingerprint = 15 C4 36 D6 EC CF 1D A4 7F D8 F9 EF 2E D7 32 A6
>
> -----BEGIN PGP SIGNATURE-----
> Version: 2.6.3i
> Charset: noconv
>
> iQCVAwUBM6MoVb3ixeOqBhAdAQG5VAQAlKM8PZ5a2V+zGynbIr/uaBvaDX32lvxI
> X2jHf8cUf5mQqk0VGTJ65oj2lDZUzONHoEepUg7Co0cZcQCu+IM1cHuuYt9HxV7j
> WwMMKHn4Ld9a8C1gXsJYGLU2g/0QU7hCRCVqO1KLthg30tSzXAWdDIy/ynHt/WJl
> 0cgWqK/Ozwo=
> =xDXn
> -----END PGP SIGNATURE-----
>
Received on Mon Jun 16 1997 - 00:00:00 CDT