extents exxceeded ?? ( need help )

From: yung-feng chang me stnt <yxc1612_at_hertz.njit.edu>
Date: 13 Aug 93 20:25:25 GMT
Message-ID: <1993Aug13.202525.10837_at_njitgw.njit.edu>


Dear netters:

        One user get following message while he is running a query.

ORA-01556 maximum number of 99 extents exceeded.

        I check the free space for the tablespace first; It still have 1.2G available!!

        Then, I try to allocate more extents for tables and tablespaces that he used. I increase max extents for the tablespace from 99 to 150, then I run his query again. I find the error message become:

ORA-01556 maximum number of 121 extents exceeded.

        No matter what max extent or extent size I increase, it seem that 121 is "ceil"??

        I find lots fragnments on that tablespace. Is this cause problem? If so, how to remove those fragnments. If not, what cause this problem?

Thanks, in advance.

Sincerely

        D. L. Received on Fri Aug 13 1993 - 22:25:25 CEST

Original text of this message