Re: spfile

Oradba Linux wrote:

> Using spfile and old fashioned rollback segments, once a bunch of new
> rollback segments are added how do you update the spfile
> so that they are online next time you recycle the database

You can create an SPFILE from the init file:

go to http://www.psoug.org
Click on Morgan's Library
click on Init SID Dot Ora

But why would you use them if you had a choice not to?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)