hi,

I am trying to create an index on a table with about 40Mil records. I am creating it in a seperate tablespace called
partition_idx .

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


Please advice
Badrinath