select TABLE_NAME,NUM_ROWS from all_tables where OWNER='xx' order by NUM_ROWS desc; 转载于:https://www.cnblogs.com/kakaisgood/p/11268912.html