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. ;-)
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: separate tablespaces for tables and indexes
- From: Gogala, Mladen
- Re: separate tablespaces for tables and indexes
- From: Niall Litchfield
Other related posts:
- » separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » RE: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- » Re: separate tablespaces for tables and indexes
- RE: separate tablespaces for tables and indexes
- From: Gogala, Mladen
- Re: separate tablespaces for tables and indexes
- From: Niall Litchfield