Oracle DBA, How To, Error, Cause and Action

ORA-03242: Tablespace migration retried 500 times

ORA-03242: Tablespace migration retried 500 times




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




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