Re: Tablespace Fragmentation

From: Roy Coleman <rcoleman_at_erols.com>
Date: 1997/10/21
Message-ID: <62is9a$980$1@winter.news.erols.com>#1/1

You must do the export and drop the tablespace to get the space contiguous again. Then do the import . That's why you got the 1547 error.

Arpege Automatismes wrote in message <344B2F45.662A_at_imaginet.fr>...
>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)
>
>
>Best Regards ,
>
> Philippe (arpege_at_imaginet.fr)
Received on Tue Oct 21 1997 - 00:00:00 CDT