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

Home -> Community -> Usenet -> c.d.o.server -> Re: Separating data, index objects

Re: Separating data, index objects

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Jun 2005 07:51:35 -0700
Message-ID: <1119538308.181941@yasure>


qazmlp1209_at_rediffmail.com wrote:
> How exaclty the index and data objects can be separated from one
> Tablespace into 2 Tablespaces? Is it possible with export/import? Or,
> is it possible with direct SQL commands also?

Same as Holger with one caveat: What is the business reason to separate them? It serves no useful purpose of which I am aware and complicates the use of transportable tablespaces.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jun 23 2005 - 09:51:35 CDT

Original text of this message

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