RE: Question re Transportable Tablespaces

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_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: Darrell Landrum [mailto:darrell_at_landrum.com] 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