Re: Obj$ table
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 30 Mar 2020 22:17:33 -0400
Message-ID: <344a222f-48e1-b56f-a7f2-92dc81b73f3f_at_gmail.com>
Date: Mon, 30 Mar 2020 22:17:33 -0400
Message-ID: <344a222f-48e1-b56f-a7f2-92dc81b73f3f_at_gmail.com>
What do you mean by "defragment"? ASSM tablespaces have few possible extent sizes which means that there is no fragmentation as in largely forgotten dictionary managed tablespaces. Also, don't ever freak with dictionary tables.
On 3/30/20 8:16 PM, Ali Alizadeh wrote:
> Hello expert
> I am trying to defragment obj$ table.
> Has anyone done this before?
>
> I appreciate any suggestions !
> Regards,
> Ali
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 31 2020 - 04:17:33 CEST