Execute the following angle, generate a file of c: /mytext.sql, run the content in the c: /mytext.sql file, you can get the number of records and tables under the current user
Connect
Userid / psw @ netservername
Set feedback off
Set heading off
Spool c: /mytext.sql
Select decode (Rownum, 1, '', 'union') || 'SELECT' || '' '|| Table_name ||' '' '||', Count (*) from '|| Table_name from User_Tables;
Spool off
