SELECTOWNER, segment_name,segment_type,TABLESPACE_NAME, sum(bytes/1024/1024/1024) GB from dba_segments where SEGMENT_TYPE = 'TABLE' AND TABLESPACE_NAME = 'CLAIM_DATA' AND owner = 'CLAIM'group by OWNER, segment_name,segment_type,TABLESPACE_NAME;
No comments :
Post a Comment