可以参考下此方法，该脚本会生成一系列 SPOOL 命令，你需要将这些命令复制到 DM 管理工具或 DM 命令行工具中执行，这样就能为每个存储过程和函数生成单独的文件。

SET FEEDBACK OFF
SET HEADING OFF
SET LINESIZE 32767
SET LONG 2000000

SELECT 
    'SPOOL /opt/' || name || '_proc.sql',
    'SELECT text FROM all_source WHERE owner = ''改成对应模式名称'' AND type = ''PROC'' AND name = ''' || name || ''' ORDER BY line;',
    'SPOOL OFF'
FROM 
    (SELECT DISTINCT name FROM all_source WHERE owner = '改成对应模式名称' AND type = 'PROC')
ORDER BY 
    name;