Hi
D2epak,
You can try to use SQL Server Profiler to monitor the process of migrating data from Oracle to SQL Server, please pay attention to the SSMA for Oracle.

Using this tool will help you finding on which step SSMA is hanging. If it is hanging on the step of migrating one data, you can try to delete it temporarily
and then migrate it separately.
If this method cannot help, you can also try to use SSIS to migrate it.
Best Regards,
Teige
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.