Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segment problem
Also, check the optimum parameter used while creating the rollback segment. That plays a great role in the RBS. I just got this problem solved using this. In 7.3 and later versions of Oracle we need to specify this while creating each rollback segment. In prior versions it was enough if we specified at the tablespace level.
Try this and see if it helps
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.
Received on Tue Jun 17 1997 - 00:00:00 CDT