ORA-03242: Tablespace migration retried 500 times



ORA-03242: Tablespace migration retried 500 times..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00102: network protocol string cannot be used by dispatchers

1 Answers  


NNL-00500: Shows information on domains served by this server

1 Answers  


ORA-01147: SYSTEM tablespace file string is offline

1 Answers  


CLSR-00521: Event string is rejected by EVM daemon

1 Answers  


NZE-28844: No wallet present

1 Answers  






TNS-12684: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


ORA-02349: invalid user-defined type - type is incomplete

1 Answers  


ORA-01288: file string is from a different database incarnation

1 Answers  


TNS-12158: TNS:could not initialize parameter subsystem

1 Answers  


PLS-00573: cannot constrain scale, precision, or range of an anchored type declaration

1 Answers  


ORA-00206: error in writing (block string, # blocks string) of controlfile

1 Answers  


NNL-00346: Save_config_on_stop is now ON

1 Answers  


Categories