More than 10,000 views of my blog

I am very pleased to see that my blog is viewed more than ten thousand time. I would encourage you all that if you have a question or a feedback then feel free to comment on the post. We learn every day, may be I can learn something new from you.

If there is any issue you are facing then you can also comment on this post with an example and I will pick it and create a new blog and try to help you. 

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

I was getting the following error while trying to create the index.

create index harvey_1647 on harvey_table( id ) tablespace INDEXES;

ERROR at line 1:

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

The message clearly says that oracle is unable to create the INITIAL extent for the segment in the tablespace INDEXES.

This means that the datafile(s) of INDEXES tablespace are unable to extend because the disk(s) are full.

To fix this move the datafile(s) to the disk which have space or add another datafile which is on the disk having space and it will fix the issue straight way.