Wednesday, 22 February 2017

How to take the Backup of a package in Oracle

set heading off
set echo off
set flush off
set pagesize 50000
set linesize 32767
set long 99999999
spool packege_body.pks
select dbms_metadata.get_ddl('PACKAGE_BODY','ERCOT_REPORT_COLLECT_PKG','SCHEMA NAME') from dual ;
spool off;

No comments:

Post a Comment

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...