Re: Tablespace Fragmentation

From: <g.r.s.deisz_at_ptt-telecom.unisource.nl>
Date: 1997/10/20
Message-ID: <62foei$cim@hdxl16.telecom.ptt.nl>#1/1

In article <344B2F45.662A_at_imaginet.fr>,

Arpege Automatismes <arpege_at_imaginet.fr> wrote:
>I have a tablespace that I would like to defragment. I have read that I
>should :
>
> 1- Export the tablespace's content
> 2- Drop the tablespace including contents
> 3- Recreate it
> 4- Import the tablespace's content
>
>What would happen if I drop the tablespace's objects one by one ? Would
>it be the same as step 2 and step 3 (it appeared that I got an ORA 1547)

No. Step 2 will also drop the tablespace, dropping all the objects will not drop the tablespace.
You do not have to drop the tablespace. You only have to coalesce it.

Stefan. Received on Mon Oct 20 1997 - 00:00:00 CDT