Try this query to show objects whose next extent is larger than the largest
free extent in the respective tablespace.
set linesize 120
col owner format a10
col segment_name format a20
col type format a7
col tablespace format a15
select a.tablespace_name tablespace,
segment_type
of objects =
free space available
Try this query to show objects whose next extent is larger
than the largest
free extent in the respective tablespace.
set linesize 120
col owner format a10
col segment_name format a20
Hi,
I have this Space Bound object script that will list every table that can
not allocate it's next extent. It will not list tables in tablespace that
is set to autoextent.
This is not entirely correct as you may have set an upper limit to the auto
extent (if you feel like adding it in please