missing tablespace_name

Hi,

   Help me to understand why tablespace_name is missing for 237 entries in the dba_tables table.. Am i missing something?

SQL> select count(*),tablespace_name from dba_tables group by tablespace_name;

  COUNT(*) TABLESPACE_NAME
---------- ------------------------------

       237
       785 SYSAUX
         8 USERS
       510 SYSTEM
        34 EXAMPLE

SQL> select count(*) from dba_tables;

  COUNT(*)

      1574

I am using oracle 10g release 2.

Advance thanks for you help.

Cheers,
WantedToBeDBA. Received on Mon May 08 2006 - 12:39:13 CDT