Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reducing extents on tables
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 --
"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 02 1999 - 05:02:57 CST