Re: Oracle 9i and PublicRollback Segment

Howard J. Rogers doodled thusly:

>Sorry -should have added that 'undo_management' just says you want to use
>the new feature. The parameter to specify which tablespace is actually to
>be used for automatic undo is 'undo_tablespace'.
>
>Should perhaps have also mentioned that you can't just point that last
>parameter at any old tablespace: you have to 'create undo tablespace
>blah....' to create the right sort of tablespace to start with.
>

that mean to start a brand new, freshly baked 9i db, it needs a startup rollback segment? Then we add the ts for undo and declare it as such in init.ora, then bounce the instance?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Nov 28 2001 - 08:12:01 CST