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

Hi,
[Quoted] 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 - 11:38:02 CET