title: Oracle SQL Developer package and package body copy and compile from one schema to another
body: <p>I have several Oracle schemas including the same PL/SQL packages and package bodies.</p>
  
  <p>If I make changes in one package in one schema, what is the best way to move these same changes to all other schemas as well ?</p>
  
  <p>I can copy the PL/SQL code from one schema and then paste it to another schema and compile there, but if this has to be done tens of times it doesn't seem appropriate to me. </p>