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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reorg?

Re: Reorg?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 26 Jan 2000 17:26:50 +0800
Message-ID: <388EBDDA.7072@yahoo.com>


Merla wrote:
>
> Hi,
> I'm new to Oracle and have a newbie question. I come from a DB2
> background want to know how to reorg a table with Oracle. Or if reorgs
> aren't done. I've looked in several manuals under REORG, SPACE,
> DATABASE, TABLE and can't find any information on how to reclaim space
> on a table that's heavily used (insert, update, delete kind of use).
>
> Thanks in advance,
> Merla

Have a look at some of the papers on space management at

www.orapub.com

You'll find that (with a little up front effort) you won't need to perform reorgs.

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jan 26 2000 - 03:26:50 CST

Original text of this message

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