This content has been marked as final. Show 1 reply
This is a simple SQL question and this forum is for SQLDEveloper, however, this is a question for our SQL*Plus support which can help with this.
set FEEDBACK off
set head off
--Gather stats to populate rownums and avg length of rows.
--These are not exact sizes (obviously) but you get the idea.
select TABLE_NAME||','||NUM_ROWS||','||ROUND((NUM_ROWS*AVG_ROW_LEN)/(1024*1024)) CSV
where num_rows is not null order by num_rows desc;