Take Backup of a Package and Package Body

Login to sqlplus as the user who owns the package/package body.

SQL>spool package_name.bkp


SQL>select text from user_source where name=’&PACKAGE NAME’ and type=’PACKAGE’;


SQL>select text from user_source where name=’&PACKAGE NAME’ and type=’PACKAGE BODY’;


SQL>Spool off;

One thought on “Take Backup of a Package and Package Body”

Leave a Reply

Your email address will not be published. Required fields are marked *