Re: online redefinition used too much undo segment?

On 25 Feb 2006 22:05:21 -0800, "Zhu Chao" <zhuchao_at_gmail.com> wrote:

>no, I believe to rollback the insert, it just need to log the rowid,
>and delete that rowid from database.
>
>To rollback a delete, it does need to save all the old value.
>
>Right?

Nonsense. A rowid is a symbolic representation of the location in the database. It is not stored at all, except in indexes. Also blocks are rearranged when a row is removed.

--
Sybrand Bakker, Senior Oracle DBA