How about EXP and IMP :-) About indexes: alter index index_name rebuild.Quote:
Oracle does not really have a good tool for "defragging" a tablespace.
Do you mean defragmenting a (permanent) tablespace? If the tablespace does not have a lot of extents, you should not worry that much. If it has, then worry, if they are not sized appropriately. If you want to "get back" chunks of a non-contiguous freespace, then only way is to export the objects and re-create the tablespace.
If you issue 'alter tablespace coalesce' command, you will only coalesce adjacent chunks of freespace.
