Re: How to defragment a ORACLE database
Date: 1996/05/19
Message-ID: <4nnkr9$3tj_at_sjx-ixn4.ix.netcom.com>#1/1
Cesar:
Assuming that the Oracle tablespaces where created on a new drive (or an unfragmented existing drive), all you need to do is to export the tables, drop the tables, and then do an import (using "compress extents" option) which creates the tables and indices. Upon re-creation, each table and index will be placed into their own extent.
-Peter
On 12 May 1996 06:47:35 -0700, cmaciel_at_bis.com.br wrote:
>Hello,
>
> How is the best way to defragment a ORACLE database? Is the method of full
>database export and full database import thw way to do it? If so, do one need
>to remove the tablespaces after exporting the database and before importing it?
>Summarizing, can anybody point me to a safe and efficient way to defragment a
>database?
>
>Thanks in advance,
>
> Cesar Diniz Maciel
> cmaciel_at_bis.com.br
Received on Sun May 19 1996 - 00:00:00 CEST