Oracle Database Discussions

Hi All,

I have a huge table with rows nearly 2 million. When this table is moved to another tablespace, the command failed giving the following error:
ORA-01652: unable to extend temp segment by 128 in tablespace XYZ

To overcome this error, an additional temp file was added with huge size. Unfortunately, the same error appeared again when the table was tried to move to another tablespace. I wonder if the new temp file was not recognized by database, so tried to see how many files belong to temporary tablespace, but the query listed the newly added temp file also.

What could be the possible reason for this error? Suggestions or clues are most welcome.

Thanks,
...