Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i and PublicRollback Segment
The old system rollback segment still exists, so no, that doesn't need to be
hand-created. The undo_tablespace parameter is also dynamic, so no, that
doesn't require an Instance bounce to change. And the 'create database'
command can also take an 'undo tablespace' clause, and create it as part of
database creation, thus giving you automatic undo management 'out of the
box'.
Regards
HJR
-- Resources for Oracle: http://www.hjrdba.com =============================== "Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3c04f057.494322_at_news...Received on Wed Nov 28 2001 - 12:55:21 CST
> 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