Re: Need to update init file for rollback segment?

Public rollback segments are 'grabbed' by the instance automatically, private rollback segments need to be in init.ora or they will not be used.

Hth,

Sybrand Bakker, Oracle DBA

"Tan Aik Khoon" <panadol_at_singnet.com.sg> wrote in message news:8lcgg5$blc$1_at_dahlia.singnet.com.sg...
> Hi,
>
> Sorry. Though I have work with oracle 8.0.5 for almost one year, I have
> not attended any course. Most information is pick up myself. However
> recently I encounter a statement in a Oracle guide book stating that once
> I create rollback segments, I should include their names in the init file
 to
> allow the database to know it exists. How far is this true, because all
 the
> while I did
> not do that. Btw my transactions are using very large that's why I create
> large rollback segments for them to use. If I do not put the statements
 in,
> will it default to certain tablespace's rollback segment? If so, what
> possible error might occur.
>
> TIA,
> Paul
>
>
Received on Sun Jul 23 2000 - 00:00:00 CDT