Re: Oracle 9i and PublicRollback Segment

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 29 Nov 2001 11:59:05 GMT
Message-ID: <3c0622e1.3356116@news>

Howard J. Rogers doodled thusly:

>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'.
>

Kool! Thanx a lot.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Nov 29 2001 - 05:59:05 CST