Sunday, 27 December 2015

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;

1 comment:

  1. For instance in 1760 the makers of Singleton's Eye Ointment a 163 year old brand, sued a few gatherings in London who forged the printed headings and duplicated the unmistakable earthenware compartment (The Total Package, 50).Europa-Road targonca szállítás Debrecen

    ReplyDelete

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!