Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reorg?
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Jan 26 2000 - 03:26:50 CST