Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GHOST ROWS ON TABLE PARTITIONED
> 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 ? Received on Fri Mar 30 2007 - 05:56:01 CDT