On 8 May 2006 09:25:32 -0700, "peter" <hhh.database_at_gmail.com> wrote:
>Hello DBAs
>
>Thank you previous answers.
>Pls tell me why oracle says to make table and Index in Different
>Tablespace to Improve Performance.How can it increase Performance,
>and according to Books undo data only go into Undo Tablespace than if
>Undo Tablespace is corrupted then how can rollback statement works and
>where is OLD Data which was updated.
>
>Pls help
>
>Thank You
- Oracle doesn't say that, or you must have read a text by KLoney,
who publishes books for every new version of Oracle just by putting a
new cover around it.
- If your undo tablespace is corrupted you need to recover the
tablespace. No escaping from that.
Undo is protected through the redo log mechanism.
--
Sybrand Bakker, Senior Oracle DBA
Received on Mon May 08 2006 - 11:39:14 CDT
