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.