oracle - 防止 SPOOL 的输出被包装

Question

我正在尝试使用 SQLPLUS 中的 SPOOL 命令为数据库中的对象生成所有 DDL:

SET trimspool ON
SET wrap off
SET heading off
SET linesize 300
SET echo off
SET pages 999
SET long 90000
Col object_type format a10000
Col object_name format a10000
Col owner format a10000

spool export.out

SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner)
FROM all_OBJECTS 
WHERE OWNER = 'DMALM' 
and object_type not like '%PARTITION'
and object_type not like '%BODY'
and object_type not like '%LOB';

spool off
quit

但是我得到的输出文件在第 80 列处被剪切。
如何防止输出文件被包装？

Answer 1

你还需要做:

SET longchunksize 90000

如 the documentation says :

The default width of datatype columns is the width of the column in the database. The column width of a LONG, BLOB, BFILE, CLOB, NCLOB or XMLType defaults to the value of SET LONGCHUNKSIZE or SET LONG, whichever is the smaller.

您正在设置 LONG已经，但是 LONGCHUNKSIZE仍然是它的默认值 80，所以你需要增加它来匹配。您可以使用 show all 查看所有当前设置.

这会保留换行符和缩进 applied by default .