源地址:http://blog.csdn.net/zhanggnol/article/details/6683697
select t.table_name,t.num_rows from user_tables t ORDER BY NUM_ROWS DESC;
还可以直接查看dblink的:
select t.table_name,t.num_rows from user_tables@dblink t ORDER BY NUM_ROWS DESC;
2021-12-12 22:36:40
源地址:http://blog.csdn.net/zhanggnol/article/details/6683697
select t.table_name,t.num_rows from user_tables t ORDER BY NUM_ROWS DESC;
还可以直接查看dblink的:
select t.table_name,t.num_rows from user_tables@dblink t ORDER BY NUM_ROWS DESC;