在Oracle中获取完整的DDL用于索引 [英] Get complete ddl for index in oracle

问题描述

我正在使用oracle 11g/12c.我想在数据库中获取索引的DDL.为此，我使用了查询-

I am using oracle 11g/12c. I want to get ddl of indexes in my database. For this I used the query -

SELECT DBMS_METADATA.GET_DDL('INDEX','SYS_IL0000091971C00001$$','CCEEXPERTS') FROM dual

这里'SYS_IL0000091971C00001 $$'是我的索引名称，而'CCEEXPERTS'是我的所有者名称.

Here 'SYS_IL0000091971C00001$$' is my index name and 'CCEEXPERTS' is my owner name.

由此我得到ddl-

 CREATE UNIQUE INDEX "CCEEXPERTS"."SYS_IL0000091971C00001$$" ON "CCEEXPERTS"."DATABLOB" (

我的实际ddl是-

CREATE UNIQUE INDEX "CCEEXPERTS"."SYS_IL0000091971C00001$$" ON "CCEEXPERTS"."DATABLOB" (
  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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" 
  PARALLEL (DEGREE 0 INSTANCES 0) ;

在"CCEEXPERTS"之后的实际ddl中."DATABLOB"(，下一行字符及其ddl被截断.

In actual ddl after "CCEEXPERTS"."DATABLOB" ( , next line character and from their the ddl is truncted.

如何获取完整的ddl?请帮助我...

How can I get the complete ddl? Please help me...

先谢谢了.

推荐答案

在SQLplus中，在运行该过程之前进行设置.

In SQLplus, set these before running the procedure.

set long 100000
set longchucksize 100000

这篇关于在Oracle中获取完整的DDL用于索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！