This query returns the table count,and the row count.
select tname,count(*) from tab group by tname;
select table_name,num_rows from user_tables
select tname,count(*) from tab group by tname;
select table_name,num_rows from user_tables
SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP';
ALTER DATABASE TEMPFILE '/u02/oracle/data/temp02.dbf' RESIZE 18M;
SELECT 'ALTER INDEX ' || a.index_name || ' REBUILD;'
FROM all_indexes a
WHERE table_owner = Upper('TEST')