Multiple Partitioned tables using the same partition

 Hi All

I am really confused with this one.

I have 2 tables that are using the same partition which belongs to the same tablespace:

select table_name, tablespace_name, partition_name from dba_tab_partitions where PARTITION_NAME='FCT_IN_STAT_20090331';

TABLE_NAME                     TABLESPACE_NAME                PARTITION_NAME
------------------------------ ------------------------------ ------------------------------
FCT_IN_STAT                    FCT_IN_STAT_20090331_DATA      FCT_IN_STAT_20090331
FCT_IN_EXTERNAL                FCT_IN_STAT_20090331_DATA      FCT_IN_STAT_20090331

SQL> select count(*) from FCT_IN_STAT partition (FCT_IN_STAT_20090331);

  COUNT(*)
----------
  41488127

SQL> select count(*) from FCT_IN_EXTERNAL partition (FCT_IN_STAT_20090331);

  COUNT(*)
----------
  47407261

Give me different counts as well.