This content has been marked as final. Show 2 replies
It's not clear if you are getting error(s) or what else. Please clarify a bit better.
We are getting alert like There are 5.0% Extents available.From where are you getting that "alert" ? and 5.0% of what ?
1 person found this helpful
how we can fine the tables, which are unable to extend their extents.Assuming fine means find, maybe something like this :
SQL> select tablespace_name,owner,segment_name,segment_type from dba_segments s 2 where next_extent > (select max(bytes) from dba_free_space f 3 where s.tablespace_name=f.tablespace_name);