Oracle Error ORA-03242: Tablespace migration retried 500 times

Oracle Error Message

ORA-03242: Tablespace migration retried 500 times

Reason for the Error

For migration to complete, temporary segments should not be present in the tablespace at the time of migration.

Solution

Avoid migrating the tablespace when there is heavy temporary segment creation going on as with object drops.