select sum(bytes) from dba_segments where tablespace_name='TABLESPACENAME'; select bytes,segment_name from dba_segments where tablespace_name='TABLESPACENAME' and bytes>100000000 order by 1;
select * from DBA_SEGEMENTS where tablespace_name ='表空间名'???我查了。提示表不存在???我用的oracle8i.不是很熟,麻烦了
谢谢~~~~bobfang,建表空间时 create tablesapce abc datafile 'e:\abc' size 2000M autoextend on default storage(initial 100M next 100M maxextents unlimited)100M给大了,赫赫
select bytes,segment_name from dba_segments where tablespace_name='TABLESPACENAME' and bytes>100000000 order by 1;
104857600 FACT_WZFKFX_PK21143877874343
104857600 SYS_C003135
104857600 PBSYSCATCOLDICT_IDX
104857600 PBSYSPBE_IDX
104857600 DIM_MZFYKPROK_PK11145345014906
104857600 DIM_MZFYKTRAN_PK11145345006453
104857600 DIM_MZFYKZGH_PK21145344997406
104857600 DIM_MZFYKZGHP_PK11145344984859
104857600 DIM_OUTGOITEM_PK11145327977828
104857600 PBSYSCATFRMTS_IDX
……
create tablesapce abc
datafile 'e:\abc' size 2000M
autoextend on
default storage(initial 100M next 100M maxextents unlimited)100M给大了,赫赫