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: Specifying default tablespaces for indexes

Re: Specifying default tablespaces for indexes

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 15 Jun 2005 16:35:39 +0100
Message-ID: <be592d5505061508356755dc26@mail.gmail.com>


there is a need, I dont want to backup indexes. I put them in a different tablespace and dont back them up, recovery time shoots up and creating indexes in parallel can be must faster than restoring from some old tape.

There are still managment reasons why you may want to do this

On 6/15/05, rjamya <rjamya_at_gmail.com> wrote:
> since the new (it isn't really new but still) wisdom says "it is not
> required to separate tables and indexes in different tablespaces", this
> whole issue becomes a moot point. I don't see any logic in being able to
> specify default index tablespace.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 15 2005 - 11:40:48 CDT

Original text of this message

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