Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Separating data, index objects
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