关于oracle用spool输出自动截行的问题,急!!!谢谢
各位大虾求教个问题,我的环境是win2003+oracle 10g,在用spool导出索引的时候发现有的表第一行导出不全,而且set linesize 1000了也不行,请各位帮忙看看,感激不尽
代码如下:
set pagesize 0
set long 90000
set feedback off
set echo off
set linesize 250
spool d:\index\1.sql
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name) FROM USER_INDEXES u where ( u.table_name in
('HR_PUB_REFEXT',
'HR_PUB_VALIDATE',
'HR_QUERYMODELDEF',
'HR_RPT_AUTH',
'HR_RPT_DEF')
);
spool off;
输出的文本如下:
CREATE UNIQUE INDEX "QQNC56"."PK_HR_PUB_REFEXT" ON "QQNC56"."HR_PUB_REFEXT" ("PK_REFEXT")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_INDEX01"
CREATE UNIQUE INDEX "QQNC56"."PK_HR_PUB_VALIDATE" ON "QQNC56"."HR_PUB_VALIDATE" ("PK_VALIDATE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_INDEX01"
CREATE UNIQUE INDEX "QQNC56"."I_HRPUB_QMD1" ON "QQNC56"."HR_QUERYMODELDEF" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_INDEX01"
CREATE UNIQUE INDEX "QQNC56"."I_HRPUB_QMD2" ON "QQNC56"."HR_QUERYMODELDEF" ("DISPLAY", "PARENTGUID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_INDEX01"
CREATE UNIQUE INDEX "QQNC56"."SYS_IL0001344291C00008$$" ON "QQNC56"."HR_QUERYMODELDEF" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_DATA01"
PARALLEL (DEGREE 0 INSTANCES 0)
CREATE UNIQUE INDEX "QQNC56"."SYS_IL0001342981C00004$$" ON "QQNC56"."HR_RPT_DEF" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "NNC_DATA01"
PARALLEL (DEGREE 0 INSTANCES 0)