Oracle Spool - 缺少完整的信息 [英] Oracle Spool - Missing complere information
问题描述
我正在尝试从我的表格元数据假脱机
信息。但文本文件在第二行结束。它不显示完整的元数据
I am trying to Spool
information from my table metadata. But the text file ends on second line. It doesn't display the complete metadata
SPOOL P_TABLES.txt
set linesize 10000
set trimspool on
set heading on
SELECT DBMS_METADATA.GET_DDL('TABLE','TABLE_X') FROM DUAL;
SPOOL OFF;
它导出一个文本文件,但不提供完整的信息。
It exports a text file but it doesn't provide complete information.
> SELECT DBMS_METADATA.GET_DDL('TABLE','TESI_STAMPDUTYLABELSVALUE') FROM DUAL
CREATE TABLE "ESIXUSER"."TESI_STAMPDUTYLABELSVALUE"
( "SVUNIDOCREFID" VAR...
//Nothing after this in .txt file.
在Oracle SQL Developer中,我可以检查完整的DLL。
Where as in Oracle SQL Developer, I am able to check the complete DLL.
我是否在sql文件中更改我的线条?
Do I do change my linesize in sql file?
推荐答案
我不确定这是否会有效,但
I am not sure exactly this will work or not but
点击此处( http://www.dba-oracle.com/t_1_dbms_metadata.htm 这可能有助于您)
Click here ( http://www.dba-oracle.com/t_1_dbms_metadata.htm " this may help for you")
我想你错过了这些:
设置标题
设置回调
设置页面999
设置长90000
set heading off set echo off Set pages 999 set long 90000
这篇关于Oracle Spool - 缺少完整的信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!