select table_name, block_size from dba_tables dt, dba_tablespaces dtbs : dba_tablespaces « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL> select table_name, block_size from dba_tables dt, dba_tablespaces dtbs
  2  where dt.tablespace_name = dtbs.tablespace_name and dt.table_name = 'ATM_DATA';

no rows selected

SQL>
SQL>
SQL>








30.44.dba_tablespaces
30.44.1.View all the tablespaces in a database
30.44.2.select table_name, block_size from dba_tables dt, dba_tablespaces dtbs
30.44.3.Query Tablespace Information