系统提示: indexes near their defined maximum number of extents.
语句为:
select owner, tablespace_name, segment_name,
extents, max_extents,
:available_extents
into &OWNER, &TABLESPACE, &INDEX_NAME, &EXTENTS, &MAXEXTS,
&AVAILABLE_EXTENTS
from dba_segments
where segment_type = 'INDEX'
and segment_name like
decode(upper(:index_name),'ALL','%',upper(:index_name))
and owner = decode(upper(:user),'ALL',owner,upper(:user))
and max_extents - extents < :available_extents
order by owner, tablespace_name, segment_name
请问我该如何设置?谢谢!
|