| Error while Rebuilding Index [message #50548] |
Thu, 21 March 2002 01:21  |
Frederik
Messages: 8
Registered: December 2001
|
Junior Member |
|
|
Hi all!
I´m having some space trouble... I erased some data, now I have to rebuild and Index. But when I try to do this I get:
"ORA-01658: unable to create INITIAL extent for segment in tablespace TEST_DAT"
Any ideas? Thanks
F.-
|
|
|
|
|
|
| Re: Error while Rebuilding Index [message #50555 is a reply to message #50548] |
Thu, 21 March 2002 03:46  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
As you mentioned that you had deleted some data, the index will be smaller. You should be able to get away with this:
1. drop index
2. coalesce the tablespace ** IMPORTANT **
3. build the index
I see that you have the table and the index in the same tablespace ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
