RE: Script to find space bound objects

Title: RE: Script to find space bound objects This is my two pence select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from     (select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a,     (select tablespace_name,max(bytes

Re: Script to find space bound objects

Jack, I think following script will do what you want... Regards Rafiq col substr(seg.owner,1,10) heading OWNER col substr(seg.segment_name,1,30) heading "SEGMENT NAME" col substr(seg.segment_type,1,10) heading "TYPE" col substr(seg.tablespace_name,1,20) heading "TS NAME" prompt *

RE: Script to find space bound objects

Jack, Here's one that we use.. -- CREATE OR REPLACE VIEW SPACE_BOUND_OBJECTS ( TS#, NAME, BLOCKSIZE, MAXFREEBLOCKS, TOTFREEBLOCKS, FREEEXTENTS ) AS select a.ts#,a.name,a.blocksize, nvl(max(b.blocks),0), nvl(sum(b.blocks),0), nvl(sum(b.blocks/b.