Recover index tablespace

From: Fabrice <test_at_test.com>
Date: Mon, 19 Oct 2009 21:00:46 +0200
Message-ID: <4adcb75e$0$987$ba4acef3_at_news.orange.fr>

Hello

How to recover index tablespace ?
I have A tablespace for the data and an onother for indexes.

. Can I restore the datafile of my index tablespace and do an un recover
tablespace. The redologs archivied will be replayed ? and Do my base will become consistent ?

. Or do I add a new datafile in my tablespace, drop the old one and rebuild
all the indexes ?
How to rebuild all the indexes ?

thanks a lot
fabrice Received on Mon Oct 19 2009 - 14:00:46 CDT

This message: [ Message body ]
Next message: joel garry: "Re: Backup Oracle, With or Without RMAN"
Previous message: Wolfram Roesler: "Re: Optimization question: Unrolling subquery into IN clause"
Next in thread: ddf: "Re: Recover index tablespace"
Reply: ddf: "Re: Recover index tablespace"
Maybe reply: Fabrice: "Re: Recover index tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message