I am moving an index to another tablespace using
alter index <indexname> rebuild tablespace <new tablsepace>;
The index segment size is 5 GB and temp tablespace is 2 GB.
I am getting the error:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Does it mean I need to increase my temp tablespace to at least 5 GB ?