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: reducing extents on tables

Re: reducing extents on tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 02 Dec 1999 19:02:57 +0800
Message-ID: <384651E1.6DEB@yahoo.com>


dougs wrote:
>
> Is there any way to reduce the number of extents on a table
> without dropping and recreating it?
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Unless the number of extents you have is massive (100's and 100's) then don't bother...

Otherwise export/import or 'alter table move' will assist --



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 Thu Dec 02 1999 - 05:02:57 CST

Original text of this message

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