title: How to Move a Stored Procedure in Oracle SQL from one Schema to Another?
body: <p>I am trying to understand what steps I need to undertake in order to move a stored procedure from one schema and into another. The schema that this is currently sitting in is going to be made redundant and I have been asked to move all tables and procedures. I have no trouble with tables but never done anything with procedures hence want to make sure I don't miss anything out.</p>
  <p>What I have currently done is look through the procedure and made a list of what its actually doing i.e. dropping/creating and inserting data into tables.</p>
  <p>After this I wasn't sure if it was just a case of copying the procedure code and then creating a new procedure on the new schema with the same code and then compiling it.</p>
  <p>I would really appreciate it if somebody could advise if I am missing anything in the steps that I am undertaking just to ensure I don't mess things up.</p>