本文介绍了在Oracle中获取完整的DDL用于索引的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用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用于索引
发布评论