Re: separate tablespaces for tables and indexes

  • From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 14 Dec 2004 10:04:57 -0600

On Tue, 14 Dec 2004 15:21:43 +0000, Niall Litchfield
<niall.litchfield@xxxxxxxxx> wrote:
> What maintenance tasks does it actually make easier?

Rebuild indexes NOLOGGING, followed by an online backup of the index
tablespace(s).  Mind you, I'm intentionally avoiding the argument on
whether or not rebuilding is necessary and/or beneficial. ;-)

Other related posts: