Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: separate tablespaces for tables and indexes

Re: separate tablespaces for tables and indexes

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Tue, 14 Dec 2004 10:04:57 -0600
Message-ID: <d4beff36041214080420d3ec65@mail.gmail.com> 





On Tue, 14 Dec 2004 15:21:43 +0000, Niall Litchfield
<niall.litchfield_at_gmail.com> 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


Received on Tue Dec 14 2004 - 10:26:44 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US