Import/Export Feedback Monitoring

If you set FEEDBACK=10000 while doing an import or export you can use the query below to estimate the number of periods you should see to indicate progress. I also included number of lob columns because this can affect the import/export speed.

select table_name,
round(num_rows/10000,2) as dots,
round(num_rows/10000/75,2) as lines,
(select count(*) from user_lobs where user_tables.table_name=user_lobs.table_name having count(*) > 0) as num_lob_cols
from user_tables
--where table_name like 'REVIEW%'
order by table_name