Re: GHOST ROWS ON TABLE PARTITIONED

On Mar 30, 5:41 am, "Andrea" <netsecur..._at_tiscali.it> wrote:
> HI,
> i've partitioned one table HA_TRANSIT_P with partition key on
> "EMISSION_DATE" column.
> The table is created and after i inserted about 60000 rows on table,
> seems ok:
>
> SELECT COUNT(*) FROM HA_EVENT_P;
>
> COUNT(*)
> ----------
> 60508
>
> but happens some strange things:
>
> 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

Which Oracle version is this?
What patch level?
Which O/S?

David Fitzjarrell Received on Fri Mar 30 2007 - 17:43:45 CDT