Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation
"vertigo" <ax178_at_wp.pl> a écrit dans le message de news:co5bp9$cjo$2_at_atlantis.news.tpi.pl...
> Hello
>
> How can i check what is maximal size of extent which i can put into
> specified tablespace ? (i create table with stotage initial values).
>
> Are there any perespectives which 'shows' me fragmentation level ?
> How can i correct fragmentation ?
>
> Thanx
> Michal
>
Use LMT (Locally Managed Tablespace) and don't bother with table fragmentation.
-- Regards Michel CadotReceived on Thu Nov 25 2004 - 13:48:19 CST