Re: defragging a tablespace/schema using exp/imp

Try the following:

Do a complete export of the data in that tablespace with COMPRESS=Y. Drop all objects from that tablespace.
Issue the command ALTER TABLESPACE <tablespace name> COALESCE; Import the data.

Cheers,
John.

Verna Legaspi <verna.legaspi_at_attws.com> wrote in message news:86adk3$6vs$1_at_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 Sun Jan 23 2000 - 19:19:54 CST