| unable to extend index xxx by 10240 in tablespace yyy [message #57297] |
Tue, 03 June 2003 05:45  |
rameshkumar
Messages: 12
Registered: May 2003
|
Junior Member |
|
|
hi all,
here i am getting a problem. kindly provide me an urgent solution
I am getting the following messages in the alert log file.
unable to extend index xxx by 10240 in tablespace yyyy.
There is plenty of space in tablespace, and percent of coalesce is also ok. what could be the problem.
any suggestion is hearlty welcome
|
|
|
|
| Re: unable to extend index xxx by 10240 in tablespace yyy [message #57298 is a reply to message #57297] |
Tue, 03 June 2003 05:54  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
we got the same problems but it seems that the biggest free block in this index-Tblsp is not big enough for the next extent (10240).
I guess you need to add a datafile or reorganize the indexes inside the tblsp (alter index xxxx rebuild)
HtH
Uwe
|
|
|
|
| Re: unable to extend index xxx by 10240 in tablespace yyy [message #57301 is a reply to message #57297] |
Tue, 03 June 2003 12:52 |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
Firstly what is your tablespace pctincrease ? If its
greater than 0 thats is your problem because each new
extent is going to 100+pctincrease of the last.
Also do check the index creation sql to check its
pctincrease is also 0.
Also check the next extent (both tablespace and
index), it is best if it is no larger than the
initial extent.
You do not say what version of Oracle you are on, but
if 8i or above then use Locally Managed Tablespaces
for all (except system which comes in 9i). It just
makes your task so much easier and helps stop this
kind of thing.
Also, its kind of obvious I know, but you do have
your data and indexes in different tablespaces ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
