I am trying to create an index on a table with about 40Mil records. I am creating it in a seperate tablespace called
After nearly 2 hours, I get this error
ERROR at line 2:
ORA-01652: unable to extend temp segment by 3200 in tablespace PARTITION_IDX
As per the oracle document, I have to add another datafile.
1) Does adding data file will suffice.
2) What does 'Temp segment' in the erro mean.
3) Can I have a datafile with AUTOEXTEND ON, SO I NEVER HAVE THIS PROBLEM