SET echo off;
SET heading off;
SET feedback off;
spool /home/oracle/spl/dba_source.sql;
select text from dba_source where type in ('PROCEDURE','TRIGGER','PACKAGE') ;
spool off;
====================================================================================
SET echo off;
SET heading off;
SET feedback off;
spool /home/oracle/spl/user_source.sql;
select text from user_source where type in ('PROCEDURE','TRIGGER','PACKAGE') ;
spool off;
sqlplus username/password as sysdba 连接数据库
执行上述脚本导出ORACLE数据库的存储过程