Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01658: unable to create INITIAL extent for segment in tablespace

nikhil1333Feb 26 2013 — edited Feb 28 2013
Hi All,


Am working on rebuilding the indexes in my database for some tables.

I am getting the below error when i execute the rebuild indexes statement, the same command i have executed for 50 other rebuild all are working fine.

I have enough space in my datafile and tablespace, please help me on this issue.


alter index master.ORDER_ITEM rebuild online tablespace MASTER_INDEX

alter index master.ORDER_ITEM rebuild online tablespace MASTER_INDEX
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace
MASTER_INDEX.

Thanks,
Nikhil Arankal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2013
Added on Feb 26 2013
#general-database-discussions
7 comments
2,564 views