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>
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:
Thanks, in advance.
Sincerely
D. L. Received on Fri Aug 13 1993 - 22:25:25 CEST