Oracle Error Codes

failed to allocate memory during R-tree creation

This feature assumes a minimum of 64K memory for bulk creation.

How to Solve :

Create the index for a small subset of the data. Then, use transactional insert operations for the rest of the data.