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: GHOST ROWS ON TABLE PARTITIONED

Re: GHOST ROWS ON TABLE PARTITIONED

From: Andrea <no_at_tin.it>
Date: Mon, 02 Apr 2007 18:51:25 +0200
Message-ID: <eurcai$4de$1@nnrp.ngi.it>


Mladen Gogala ha scritto:
> On Fri, 30 Mar 2007 04:09:46 -0700, Andrea wrote:
>

>> now i try to recreate table and reinsert rows...

>
> What is the meaning of "recreate"? Do you mean "drop and create
> again"? Dropping table has a potential to damage statistics.
> That is April fools day way of putting it.
> Please, include re-calculation of statistics in the "recreate"
> procedure. Statistics comes to us by means of intelligunt desine
> and it needs an almighty hand to gather it after creating the table
> by "let there be table" statement.
>

ok,.. but, how i include re-calculation of statistics ? Received on Mon Apr 02 2007 - 11:51:25 CDT

Original text of this message

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