Re: Question about undo

On Tue, 29 Jul 2008 10:44:45 -0700 (PDT), artmerar_at_yahoo.com wrote:

>
>Hi,
>
>We just migrated to Oracle 10g, from 8i. We had one question about
>UNDO. The documentation states that the UNDO table space keeps the
>'undo' information for whatever time you specify and then writes it to
>disk.
>
>Does this mean that the rollback segments are no longer used and can
>be removed/deleted from the system/init.ora?

undo segments succeed rollback segments. If you use undo segments you'll don't need rollback segments anymore.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA