Re: ignored duplicate rollback segment

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0311170617.1a2f78a1_at_posting.google.com>...
> yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311170018.353f8111_at_posting.google.com>...
> > i have this set of messages appearing regularly in my alert file.
> >
> > Ignored duplicate rollback segment 12 in ROLLBACK_SEGMENTS parameter
> > Ignored duplicate rollback segment 2 in ROLLBACK_SEGMENTS parameter
> > Ignored duplicate rollback segment 13 in ROLLBACK_SEGMENTS parameter
> > Ignored duplicate rollback segment 14 in ROLLBACK_SEGMENTS parameter
> > Ignored duplicate rollback segment 15 in ROLLBACK_SEGMENTS parameter
>
> So verify the rollback_segments parameter in init.ora and discover you
> do have duplicated segment names in it.
>
> Sybrand Bakker
> Senior Oracle DBA

in my initsid.ora, i had the following rollback segments rollback_segments = (PRS_1,PRS_10,PRS_11,PRS_12,PRS_13,PRS_14,PRS_2,PRS_3,PRS_4,PRS_5,PRS_6,PRS_7,PRS_8,PRS_9,

prs_10, prs_11,
prs_12, prs_13, prs_14, prs_15, prs_16, prs_17, prs_18, prs_19,
prs_20, prs_21, prs_22, prs_23, prs_24, prs_25, prs_26, prs_27,
prs_28, prs_29, prs_30)

as you could see.... rollback segment, 12, 13, 14, are declared twice.

but PRS_2, prs_15 are declared once.

my understanding tells me that PRS_12 and prs_12 are the same, irregardless of big case?

another question is what happens to PRS_2, prs_15. they are declared once only. Received on Mon Nov 24 2003 - 11:03:30 CST