defragging a tablespace/schema using exp/imp

From: Verna Legaspi <verna.legaspi_at_attws.com>
Date: Fri, 21 Jan 2000 11:52:37 -0800
Message-ID: <86adk3$6vs$1@redftp.redftp.attws.com>

Hi,

I'm fairly new to this, but I want to make sure I'm doing the correct thing. We just completed upgrading 3rd party software that does a bunch of changes to it's schema objects. All of its objects are in one tablespace. No other 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 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 - 13:52:37 CST