On Thu, 30 Sep 2004 01:31:55 -0700 (PDT), Nirmal Kumar M <gm_nirmal@xxxxxxxxx> wrote: > > 3. But here the question is how the data which has > been archived, how that can be rollbacked and how that > can be removed from Archived files.?? > > ===== Please read the concepts manual section on both Rollback Segments/UNDO, and on REDO and Archive logs. I suspect you have a backgound in Sybase or SQL server, both of which use the redo data for both redo and undo. Oracle has no such limitation. :) -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l