How to Take Backup of Package and Package Body in Oracle

How to Export Package in Oracle Database:

SET HEADING OFF
SET ECHO OFF
SET FLUSH OFF
SET LINES 200 PAGES 50000
SET LONG 99999999
SPOOL PACKAGE_NAME.pks
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<PACKAGE_NAME>','<OWNER>') FROM DUAL;
SPOOL OFF;

How to Export Package Body in Oracle Database:

SET HEADING OFF
SET ECHO OFF
SET FLUSH OFF
SET LINES 200 PAGES 50000
SET LONG 99999999
SPOOL PACKAGE_BODY_NAME.pkg
SELECT DBMS_METADATA.GET_DDL('PACKAGE','<PACKAGE_BODY_NAME>','<OWNER>') FROM DUAL;
SPOOL OFF;




Post a Comment

© Ayaan Israr - All rights reserved. Premium By Ayaan Israr