Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Defrag Tablespaces ? How ?
We actually use Tsreorg for defrag tablespaces.
It dumps the contents out of a tablespace and then does a coalesce of the
tablespace and loads it all back in.
This is what I calls a defrag.
Ton Raaijmakers
satar_at_my-dejanews.com wrote:
> 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
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 15 1998 - 04:04:21 CDT