FreeLists / oracle-l / RE: Question re Transportable Tablespaces

["William Wagman" <wjwagman@xxxxxxxxxxx>]

Darrell,

A follow-up question if I may. The docs say function-based indexes will
not transport. I don't have things configured yet so am not prepared to
test but am wondering how they are handled. DO they just not go, can
they be rebuilt after the tablespaces is moved or must they first be
dropped and then recreated?

Thanks. 


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Darrell Landrum [mailto:darrell@xxxxxxxxxxx] 
Sent: Friday, May 25, 2007 6:33 PM
To: William Wagman
Cc: oracle-l
Subject: Re: Question re Transportable Tablespaces

Nope, not necessary.  All it means is that tablespaces containing  
dependent objects must be transported together.
If tablespace_t contains your tables and tablespace_i contains your  
indexes for those tables, both tablespaces must be included in order  
to transport.


On May 25, 2007, at 6:30 PM, William Wagman wrote:


> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l