August 21, 2013

PROCEDURE BACKUP IN ORACLE

PROCEDURE BACKUP
----------------
set heading off
set feedback off
set trimspool on
set echo off
set flush off
set pagesize 0
set linesize 32767
set long 99999999

spool PROCEDURE_NAME.LOG
select dbms_metadata.get_ddl('PROCEDURE','&PROCEDURE_NAME','&OWNER_NAME') from dual
/
spool off;

OR

set pagesize 0
set linesize 800
set trimspool on
set heading off
set feedback off

spool PROCEDURE_NAME.LOG
select text from dba_source where owner='&OWNER_NAME'and name='&PROCEDURE_NAME'
/
spool off;

1 comment:

  1. Workday HCM certification training provided me with solid HR and payroll knowledge. Great choice for advancing in HR tech careers.

    ReplyDelete