Re: How do I assign rollback segments to Members?

 Er, I think you are getting a little confused between *rollback segments* and *redo log groups/members*..? Have a look at the Oracle Server Concepts manual and go on some Oracle Training courses.

Basically, if you've created your new rollback segments - in your rollback segment tablespace? (i.e., don't just create them anywhere) - then once you bring them ONLINE (which they may already be, but check DBA_ROLLBACK_SEGS) they will be available for use.

Steve Phelan.

SatarNag wrote in article <19970730204101.QAA24385_at_ladder01.news.aol.com>...

>Oracle 7.3
>
>I have created new roll back segments, how do I assign them to the
>rollback members?
>
>Rollback Groups --> Rollback Members --> Rollback Segments
>
>Thank You Once again,
>Satar Naghshineh
>
>P.S. I just aquired an Entry-level Oracle DBA position, and the
>consultant who is supposed to train me, is working on other projects...So
>I am alone (with my Oracle education, and my handy books) so please excuse
>my frequent postings for help. God Bless the Newbies. ;)
Received on Thu Jul 31 1997 - 00:00:00 CDT