Re: fragmentation

From: Jim Cheng <jinxcheng_at_hotmail.com>
Date: Fri, 26 Nov 2004 14:13:56 -0800
Message-ID: <co89rc$oms$1@news.Stanford.EDU>

Try this command:

alter tablespace XXX coalesce;
This command does not work on temporary tabelspace though.

Regards,
Jim

"vertigo" <ax178_at_wp.pl> wrote in message 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
>
Received on Fri Nov 26 2004 - 16:13:56 CST