首先用拥有DBA权限的用户登录Oracle
然后新建SQL窗口执行下面语句:
select NUM_ROWS,TABLE_NAME,t.owner,t.tablespace_name from dba_all_tables t order by nvl(t.num_rows,0) desc
首先用拥有DBA权限的用户登录Oracle
然后新建SQL窗口执行下面语句:
select NUM_ROWS,TABLE_NAME,t.owner,t.tablespace_name from dba_all_tables t order by nvl(t.num_rows,0) desc