Re: Tablespace Fragmentation

Which version of Oracle7 u'r using? If its 7.3 then u can avoid the cumbersome process of export and import. Its enough if u do,

alter tablespace <tablespace name> coalesce;

Arpege Automatismes 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)
>
> Best Regards ,
>
> Philippe (arpege_at_imaginet.fr)
 

-- 
*****************************************************************
"There are no strangers in life, only friends you've not yet met"
Srinivasan Sankar                         srinisankar_at_hotmail.com
*****************************************************************
P.S:- Replace "nospam" with "hotmail" while replying to me