To free a db file, no other solution than exp/imp ??

From: <monsri_at_my-deja.com>
Date: Wed, 24 Jan 2001 10:35:25 GMT
Message-ID: <94mb5d$oo6$1@nnrp1.deja.com>

Hi,
I've purged a datafile that's almost 2G big, on which I still have 17 segments. Due to fragmentation, I still can't resize this file to anything, although all 17 remaining segments amount to about 50M in size in this file !

My question is: is there NO OTHER WAY of re-gathering together this file's extents than through an export/import, in order to resize it afterwards ??

NO OTHER WAY AT ALL ?? Thks !
BO'M

(here is the SQL I use to visualize my file's fragmentation:
> select segment_name, block_id, blocks, file_id
> from dba_extents
> where file_id=&&1
> union
> select 'free' segment_name, block_id, blocks, file_id
> from dba_free_space
> where file_id=&&1
> order by file_id,block_id
> /)

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 04:35:25 CST