Vikas,

The answer is an enthusiastic yes. This is purely from
an administrative and manageability standpoint. For
example, if you have INDEX and DATA segments separated
in 2 different tablespaces, the backup of these
tablespaces can be done INDEPENDENTLY. This is
relevant, as if you were to rebuild your indexes using
the NOLOGGING option between 2 backup jobs. If that
were the case, then all you will need to do after the
rebuild is complete, is to backup only the INDX
tablespace.

This is a best practice (if not a requirement) in most
production shops, unless you think you can re-re-build
your indexes in the event of media failure and you
lose your INDX tablespace.


Hope that helps,


Gaja
--- vikas kawatra <[EMAIL PROTECTED]> wrote:
> Guys,
> 
> Does it make sense to separate data and index
> segments into separate
> tablespaces if you create a single logical volume
> and all files are
> striped using the SAME methodology ?
> 
> Thanks
> 
> vikas
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: vikas kawatra
>   INET: [EMAIL PROTECTED]
> 


=====
Gaja Krishna Vaidyanatha
Principal Technical Product Manager, 
Application Performance Management, Veritas Corporation
E-mail : [EMAIL PROTECTED]  Phone: (650)-527-3180
Website: http://www.veritas.com

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to