select t.table_name ,owner from dba_tables t where t.tablespace_name='USERS'
----------------------------
select t.table_name,t.column_name,t.data_type,t.data_length,t.data_precision ,t.nullable from user_tab_columns t where t.table_name = 'CHAINED_ROWS'
select t.table_name,t.column_name,t.data_type,t.data_length,t.data_precision ,t.nullable from user_tab_columns t where t.table_name = 'Table1' and t.column_name = 'NAME'