Transportable Tablespaces and Function Based Indexes

From: MacGregor, Ian A. <>
Date: Mon, 24 May 2010 12:56:46 -0700
Message-ID: <>

I need to transport a tablespace which has over 20 FBI's. The database version is on both sides. Transportable tablespaces do not support materialized views nor FBI's. The materialized views are not a problem as they can be recreated with the "on prebuilt table" syntax. But what about the FBI's? Do they need to dropped before the export , and recreated afterwards?

Ian MacGregotr
SLAC National Accelerator Laboratory-- Received on Mon May 24 2010 - 14:56:46 CDT

Original text of this message