title: Backup of package in oracle plsql
body: <p>I am new to pl/sql, I have a pkg_body and I want to make changes to it. But before doing that I want to take backup of the original pkg. So can I create a new pkg with name **_bkp and just copy the code into it.</p>
  
  <p>I have found the below code when searched on net</p>
  
  <pre><code>set pagesize 0
  set linesize 800
  set trimspool on
  set heading off
  set feedback off
  spool filename.pkb
  select text from dba_source where name='objectname' and type='PACKAGE BODY';
  spool off
  exit
  </code></pre>
  
  <p>But should I do this?Cant I create a new pkg with different name and copy the original code into it hen make the changes?</p>
  
  <p>Thanks</p>