column owner format A7
column bytes format 99999999999
break ON owner  ON report
compute SUM  OF bytes ON owner report
 
SELECT owner, table_name, NVL(num_rows*avg_row_len,0) bytes
FROM dba_tables
WHERE tablespace_name=’E_DATA’
ORDER BY owner,table_name
/
SELECT (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.