Re: Removing Clusters

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Sun, 12 Dec 1999 13:17:45 +0100
Message-ID: <38539269.9B371F7B@wxs.nl>

TAD wrote:
> We are moving from 7.2.2.3 on HP-UX 10.20 to 8.0.5 on the same platform. We
> found that we do not need the clusters we have anymore. What is the best way
> of removing the current clusters and replacing the clustered tables with
> normal tables ?
> The only thing we could think of was to export the tables and to then import
> them. Unfortunately, Oracle export defaults the initial extent size of each
> table to the initial extent of the cluster.
> Is there a cleaner way of doing this ?

If you create the tables before the import then the import will not recreate
that table and your settings will remain. imp has an option that tells imp to ignore object creation errors.

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Sun Dec 12 1999 - 06:17:45 CST