defragging a tablespace/schema using exp/imp

[Quoted] [Quoted] I'm fairly new to this, but I want to make sure I'm doing the correct thing. [Quoted] We just completed upgrading 3rd party software that does a bunch of changes [Quoted] to it's schema objects. All of its objects are in one tablespace. No other [Quoted] users use this tablespace. The schema has 169 objects after the upgrade. Prior to the software upgrade, its tablespace had less than 5 pieces. After [Quoted] the upgrade, the tablespace has 117 pieces.

I've made a full DB export & a schema export. I would like to know what's the best way to defrag this tablespace. I only know how to delete all the datafiles, re-create the database, and do a full import. Surely there's a more efficient way to do this if I only care to defrag one tablespace?

TIA,
Verna Received on Fri Jan 21 2000 - 20:52:37 CET