Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Defrag Tablespaces ? How ?

Re: Defrag Tablespaces ? How ?

From: Ton Raaijmakers <torgan_at_worldonline.nl>
Date: Thu, 15 Oct 1998 11:04:21 +0200
Message-ID: <3625BA94.FD4437A9@worldonline.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US