The reason you are getting this error is because your tablespace ran out of space where the index resides.
SELECT TABLESPACE NAME FROM USER_INDEXES WHERE INDEX_NAME = '&INDEX_NAME'; -- provide the index_name that is failing to get extent allocationBased on the tablespace named from the top, ask your DBA to:
ALTER TABLESPACE <tablespace_name_from_above_query> ADD DATAFILE 'full directory path within quotes with a file name' SIZE <a reasonable size in MBs denoted with the letter M>
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.