title: Moving Oracle objects between schemas (unicity constraints restrictions)
body: <p>Actually on <strong>Oracle 10g</strong>.
  We could migrate to <strong>12c</strong> if this can help us out.</p>
  
  <ul>
  <li>We 2 <em>schemas</em> : <strong>A_ADMIN</strong> and <strong>A2</strong>.</li>
  <li>Main <em>schema</em> is <strong>A2</strong> which contains some <em>synonyms</em> pointing to <strong>A_ADMIN</strong> <em>tables</em>.</li>
  <li>We'd like to move referenced <strong>A_ADMIN</strong> <em>objects</em> to <strong>A2</strong> <em>schema</em> so only one <em>schema</em> would be needed.</li>
  <li>There are <em>triggers, packages, indexes, unicity constraints</em>...</li>
  </ul>
  
  <p>What's the best way to proceed, considering we have development and production environment so <strong>we'd like to prepare migration script(s)</strong> to do so ?</p>