ORA-03242

Error: ORA-03242: Tablespace migration retried 500 times

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

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