Re: exp/imp Oracle Clusters in 7.3.4

From: MarkP28665 <markp28665_at_aol.com>
Date: 8 Dec 1998 23:45:25 GMT
Message-ID: <19981208184525.08094.00001964@ng-cr1.aol.com>

From: Michael Brennan >>
I can't seem to find any information on Clusters anywhere, <<

See The Oracle Concepts Manual for ver 8 has information about clusters in Ch 8 Schema Objects and Ch 4, Managing Schema Objects, of the Application Developers Guide discusses how to manage clusters.

Yes clusters reuse space from deleted rows and yes they take extents to handle growth. To re-org a cluster you could export all the tables in the cluster, drop them, potentialy drop and recreate the cluster, and import the tables. But the manuals will give you a better answer.

I hope this helps.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Dec 08 1998 - 17:45:25 CST