Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GHOST ROWS ON TABLE PARTITIONED
On 30 Mar, 12:56, "astalavista" <nob..._at_nowhere.com> wrote:
> > SELECT TABLE_NAME,PARTITION_NAME,NUM_ROWS FROM USER_TAB_PARTITIONS;
>
> > TABLE_NAME PARTITION_NAME NUM_ROWS
> > --------------------- --------------- ----------
> > -------------------
> > HA_EVENT_P ENTRO_MARZO02
> > HA_EVENT_P DOPO_MARZO02
>
> > or:
> > SELECT TABLE_NAME,NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME =
> > 'HA_EVENT_P';
>
> > TABLE_NAME NUM_ROWS
> > -------------------- -----------------
> > HA_EVENT_P
>
> > the numbers of rows on USER_TAB_PARTITIONS and USER_TABLES are null !!
> > although, the select count(*) give the numbers of rows on table
> > partitioned..
>
> > what could be happened? why i don't see the num. rows with query on
> > these views??
>
> > thanks very much
> > andrea
>
> Have you calculate stats ?
of course.
exec dbms_stats.gather_table_stats('TEST','HA_EVENT_P',CASCADE=>TRUE);
now i try to recreate table and reinsert rows... Received on Fri Mar 30 2007 - 06:09:46 CDT