Re: Defrag Tablespaces ? How ?

From: <satar_at_my-dejanews.com>
Date: Wed, 14 Oct 1998 18:53:33 GMT
Message-ID: <702rvd$udg$1@nnrp1.dejanews.com>

I looked into Platinum, it doesn't defrag a tablespace. The only way to defrag a tablespace has already been stated (export objects & import objects & coalesce). If you're in a 24x7 enviroment, you're screwed. I would create a standby database (configuired properly with all tables in one extent, and the tablespaces looking good) and switch the production onto the standby. Fix the production, then switch back (not necessary).

Satar
In article <36248C1A.7E5E3802_at_worldonline.nl>, Ton Raaijmakers <torgan_at_worldonline.nl> wrote:
> You can reorg a tablespace but you have to buy a utility.
> Tsreorg from Platinum can do this.
>
> Ton Raaijmakers
>
> Asko Tiidumaa wrote:
>
> > > you can't export a tablespace, you can only export all tables in a
> > > tablespace, indexes you must drop and recreate them (Release < 7.3) ...
> > > Then you must drop the tablespace and recreate it or
> > > set default storage (pctincrease 1) for it ( not 0) so that SMON
> > > coalesces all free extents or
> > > in Oracle release greater 7.3 "alter tablespace USERS coalesce;"
> >
> > but 24*7 availability?
> >
> > Asko Tiidumaa
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 14 1998 - 13:53:33 CDT