Re: reducing extents on tables

From: David Scott <dlscott_at_mindspring.com>
Date: Wed, 01 Dec 1999 23:11:57 -0500
Message-ID: <3845F18D.2977B39C@mindspring.com>

Try this, assuming a table TARGET in the tablespace TARGET_DATA:

create table target_tmp as select * from target; -- use storage options, etc.
truncate table target;
alter tablespace target_data coalesce;
alter table target storage (next 1M); -- set next to whatever you want insert into target select * from target_tmp; commit;

OTOH, a simple export/drop/import is not a bad deal. Any particular reason you don't want to drop/recreate? That might affect things, of course.

dougs wrote:
>
> Is there any way to reduce the number of extents on a table
> without dropping and recreating it?
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Wed Dec 01 1999 - 22:11:57 CST