GHOST ROWS ON TABLE PARTITIONED

From: Andrea <netsecurity_at_tiscali.it>
Date: 30 Mar 2007 03:41:21 -0700
Message-ID: <1175251281.803534.81760@o5g2000hsb.googlegroups.com>

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 Received on Fri Mar 30 2007 - 05:41:21 CDT