我以sysdba身份登录系统select segment_type,segment_name,(select count(*) from segment_name) RowsNum
from dba_segments where tablespace_name = 'USERS' and segment_type = 'TABLE'就是那个计数项怎么报错呢???不会不支持自查询吧?
from dba_segments where tablespace_name = 'USERS' and segment_type = 'TABLE'就是那个计数项怎么报错呢???不会不支持自查询吧?
select segment_type,segment_name,coun(*) RowsNum
from dba_segments where tablespace_name = 'USERS' and segment_type = 'TABLE'
group by segment_type,segment_name