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;
----------------
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;
No comments:
Post a Comment