MySQL to Oracle DB Migration
<p>I have a task to Migrate MySQL DB to Oracle (its my requirement) i tried to Migrate using SQL developer as defined in below link. </p>

<blockquote>
  <p><a href="https://www.packtpub.com/books/content/migrating-mysql-table-using-oracle-sql-developer-15" rel="nofollow">https://www.packtpub.com/books/content/migrating-mysql-table-using-oracle-sql-developer-15</a></p>
</blockquote>

<p>As the DB is huge, the constraints are not copied properly from MySQL to Oracle, i need to define/alter/add constraints explicitly, which is time consuming (SQL developer migrates data 300rec/min from mysql to Oracle) &amp; the entire procedure, views, functions is need to re write. </p>

<ol>
<li>How can i ensure that data has migrated properly or not.?  </li>
<li>Is this is a right approach to migrate?  </li>
<li>Should i move to any tool which helps to Migrate? If yes please suggest the     tool..!! </li>
<li>Or it is the right thing to Move from MySQL to Oracle.</li>
</ol>

<p>Thanks in Advance.</p>