dbms_space.free_space[9]

what auto segment space management ts's?  march 20, 2003
reviewer:  matt  from australia

what should the value of freelist_group_id be in each call to 
dbms_space.free_blocks? you default your value to 1, should this be 1 for tables 
in all cases?

i just executed dbms_space.free_blocks for a segment in a locally managed ts 
with auto segment space management
and got the following error:

10618, 00000, "operation not allowed on this segment"
// *cause:  this dbms_space operation is not permitted on segments in
//          tablespaces with auto segment space management
// *action:  recheck the segment name and type and re-issue the statement

how do you identify free blocks in this case? 

i just assumed one freelist.  if you have more, this routine is not 
"sophisticated enough"



there is a dbms_space.space_usage routine for assm 

your show_space procedure and partitoned tables  may 06, 2003
reviewer:  pingu

hi

i am trying to use your show_space procedure but it seems that it does not work 
with partitioned tables?

i think the cursor

for x in ( select tablespace_name
             from dba_tablespaces
            where tablespace_name = ( select tablespace_name
                                        from dba_segments
                                       where segment_type = p_type
                                         and segment_name = p_segname
                                         and segment_space_management <> 'auto' 
)

the subquery should we add distinct? 

go for it.  i adjust it as i need.