Re: Online rollback segs on startup

David,

Public rollback segments are automatically put online when you startup the database. however, private rollback segments will only go online if you include them in the init.ora file or if you start them up after the fact.

dlutz_at_symantec.com (David Lutz) wrote:

>I an aware that a ROLLBACK_SEGMENTS statement in the parameter initialization file
>for Oracle 7 will put user created rollback segments online upon database startup.
>However, I also see that rollback segments the Oracle Server installer created are
>online upon startup but they are not in the paramteter initialization file. Can anyone
>tell me how this is done? How can rollback segments be kept online even though they
>are not in the parameter initialization file? The Oracle rollbacks I am refering
>are in a table space named ROLLBACK_DATA and are PUBLIC. My rollbacks segments are
>in a tablespace I created. The tablespace is online but the rollbacks segments are not.
 

>Thanks in advance.
 

>David Lutz
>dlutz_at_tlsolutions.com
Received on Sat Dec 09 1995 - 00:00:00 CET