Space_Count

**   select user_bytes/1024/1024 from dba_data_files

        where tablespace_name='<tbs_name>';

** select sum(user_bytes)/1024/1024 from dba_data_files

      where tablespace_name='<tbs_name>';

  

        This will give us the space used in a particular datafile.....

Tablespace_Size

** select bytes/1024/1024 from dba_data_files

      where tablespace_name='<tbs_name>';

** select sum(bytes)/1024/1024 from dba_data_files

      where tablespace_name='<tbs_name>';

   

        This command will give the tablespace size what size is the tablespace created of..