2 Replies Latest reply: Jan 11, 2013 8:02 AM by Paul M. RSS

    Unable to extend

    user7490278
      Hi all,


      sorry, Giving clear query now...

      Database version is 8.1.7. In this database there are some dictionary managed tablespaces. In that one of table might be not able to extend to max size.

      does any one have idea about how we can fine the tables, which are unable to extend their extents.


      thank you

      Edited by: user7490278 on Jan 11, 2013 5:33 AM

      Edited by: user7490278 on Jan 11, 2013 5:34 AM
        • 1. Re: Unable to extend
          Paul M.
          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 ?
          • 2. Re: Unable to extend
            Paul M.
            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);