hi! Guys ,

FYI ...

The problem was that I did not have enough space on the tablespace
where the spatial index was being created.

Increased the space and
it created the spatial index.