Say I want to get the DDL for all indexes for CO tables in PS, I run the following:
[sourcecode language='sql' ]
SELECT 'SELECT DBMS_METADATA.GET_DDL(''' || 'INDEX''' || ',''' || index_name || '''' || ',''' || 'PS910' || ''') || ' || '''' || ';''' || ' as txt FROM dual ;'
from all_indexes t1 where t1.table_owner = 'PS910'
and t1.table_name like 'F987%' and length(table_name) < 10 ;
[/sourcecode]
I then Cut and paste the results of this (as below) in between the 3 header lines, they are vital, including eh word wrap on 121, txt.
[sourcecode language='sql' ]
set long 200000 pages 0 lines 131
column txt format a121 word_wrapped
spool D:\myriad\generateINdex.sql
SELECT DBMS_METADATA.GET_DDL('INDEX','F98710_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98710_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_4','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_6','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98711_7','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98712_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98712_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_3','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_4','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_5','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98713_6','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98720_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98720_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98740_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98740_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98740_4','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98740_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98741_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98741_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98743_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98743_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98743_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98745_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98750_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98750_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_3','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_5','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_6','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98751_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98752_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98752_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98753_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98753_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98753_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98753_4','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98760_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98760_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98760_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_3','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_6','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_5','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98761_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_6','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_0','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_1','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_2','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_3','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_4','PS910') || ';' as txt FROM dual ;
SELECT DBMS_METADATA.GET_DDL('INDEX','F98762_7','PS910') || ';' as txt FROM dual ;
spool off;
quit;
[/sourcecode]
Which generates the following, which I also run with SQL Plus
[sourcecode language='sql' ]
CREATE UNIQUE INDEX "PD910"."F98710_0" ON "PD910"."F98710" ("THOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98710_1" ON "PD910"."F98710" ("THTBID", "THOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98711_0" ON "PD910"."F98711" ("TDOBNM", "TDOBND")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98711_4" ON "PD910"."F98711" ("TDOBNM", "TDDDID", "TDOBND")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98711_1" ON "PD910"."F98711" ("TDTBID", "TDDDID", "TDOBNM", "TDOBND")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98711_2" ON "PD910"."F98711" ("TDDDID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98711_6" ON "PD910"."F98711" ("TDOBND")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98711_7" ON "PD910"."F98711" ("TDOBNM", "TDPSEQ")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98712_0" ON "PD910"."F98712" ("TPOBNM", "TPINID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98712_1" ON "PD910"."F98712" ("TPTBID", "TPINID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98713_0" ON "PD910"."F98713" ("TLOBNM", "TLOBND", "TLINID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_1" ON "PD910"."F98713" ("TLTBID", "TLDDID", "TLINID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_2" ON "PD910"."F98713" ("TLDDID", "TLCMPI", "TLINID", "TLTBID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_3" ON "PD910"."F98713" ("TLTBID", "TLINID", "TLCMPI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_4" ON "PD910"."F98713" ("TLOBNM", "TLDDID", "TLINID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_5" ON "PD910"."F98713" ("TLDDID", "TLCMPI", "TLINID", "TLOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98713_6" ON "PD910"."F98713" ("TLOBNM", "TLINID", "TLCMPI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98720_0" ON "PD910"."F98720" ("BVOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98720_1" ON "PD910"."F98720" ("BVBVID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98740_1" ON "PD910"."F98740" ("ELPRDTYP", "ELAPPLID", "ELFORMID", "ELCTRLID", "ELWEVENT",
"ELERID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98740_2" ON "PD910"."F98740" ("ELOBNM", "ELPRDTYP", "ELFORMID", "ELCTRLID", "ELWEVENT", "ELERID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98740_4" ON "PD910"."F98740" ("ELPRDTYP", "ELOBNM", "ELFMNM", "ELCTRLID", "ELWEVENT", "ELERID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98740_0" ON "PD910"."F98740" ("ELPRDTYP", "ELOBNM", "ELVERS", "ELFMNM", "ELCTRLID",
"ELWEVENT", "ELERID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98741_0" ON "PD910"."F98741" ("ESEVSK", "ESEVSEQ")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98741_1" ON "PD910"."F98741" ("ESEVSPEC", "ESEVSEQ")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98743_0" ON "PD910"."F98743" ("DTOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98743_1" ON "PD910"."F98743" ("DTTMPLID", "DTTMPLNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98743_2" ON "PD910"."F98743" ("DTOBNM", "DTTMPLTYP", "DTTMPLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98745_0" ON "PD910"."F98745" ("SFOBNM", "SFNMNAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98750_0" ON "PD910"."F98750" ("FTOBNM", "FTTEXTID", "FTLNGP", "FTSY")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98750_1" ON "PD910"."F98750" ("FTAPPLID", "FTTEXTID", "FTLNGP", "FTSY")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98751_3" ON "PD910"."F98751" ("FSOBNM", "FSRCRDTP", "FSGNCID1", "FSCTRLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98751_1" ON "PD910"."F98751" ("FSAPPLID", "FSRCRDTP", "FSGNCID1", "FSGNCID2", "FSWEVENT",
"FSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98751_5" ON "PD910"."F98751" ("FSOBNM", "FSRCRDTP", "FSFMNM", "FSCTRLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98751_6" ON "PD910"."F98751" ("FSRCRDTP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98751_0" ON "PD910"."F98751" ("FSOBNM", "FSRCRDTP", "FSFMNM", "FSGNCID2", "FSWEVENT",
"FSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98751_2" ON "PD910"."F98751" ("FSOBNM", "FSRCRDTP", "FSGNCID1", "FSGNCID2", "FSWEVENT",
"FSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98752_0" ON "PD910"."F98752" ("AHOBNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98752_1" ON "PD910"."F98752" ("AHAPPLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98753_0" ON "PD910"."F98753" ("ADOBNM", "ADFMNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98753_1" ON "PD910"."F98753" ("ADAPPLID", "ADFRMID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98753_2" ON "PD910"."F98753" ("ADFRMID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98753_4" ON "PD910"."F98753" ("ADFMNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98760_0" ON "PD910"."F98760" ("RTOBNM", "RTVERS", "RTTEXTID", "RTLNGP", "RTSY")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98760_1" ON "PD910"."F98760" ("RTREPORTID", "RTTEXTID", "RTLNGP", "RTSY")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98760_2" ON "PD910"."F98760" ("RTOBNM", "RTTEXTID", "RTLNGP", "RTSY")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98761_3" ON "PD910"."F98761" ("RSOBNM", "RSRCRDTP", "RSGNCID1", "RSCTRLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98761_6" ON "PD910"."F98761" ("RSRCRDTP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98761_5" ON "PD910"."F98761" ("RSOBNM", "RSVERS", "RSRCRDTP", "RSGNCID1", "RSCTRLID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98761_0" ON "PD910"."F98761" ("RSOBNM", "RSVERS", "RSRCRDTP", "RSGNCID1", "RSGNCID2",
"RSWEVENT", "RSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98761_1" ON "PD910"."F98761" ("RSREPORTID", "RSRCRDTP", "RSGNCID1", "RSGNCID2", "RSWEVENT",
"RSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98761_2" ON "PD910"."F98761" ("RSOBNM", "RSRCRDTP", "RSGNCID1", "RSGNCID2", "RSWEVENT",
"RSGNCID3")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98762_6" ON "PD910"."F98762" ("BCSRCFNM", "BCFNNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98762_0" ON "PD910"."F98762" ("BCFNNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98762_1" ON "PD910"."F98762" ("BCBHVRID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98762_2" ON "PD910"."F98762" ("BCSRCFNM", "BCBHVRID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98762_3" ON "PD910"."F98762" ("BCOBNM", "BCBHVRID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE INDEX "PD910"."F98762_4" ON "PD910"."F98762" ("BCOBNM", "BCSRCFNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
CREATE UNIQUE INDEX "PD910"."F98762_7" ON "PD910"."F98762" ("BCOBNM", "BCFNNM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "PD910I" ;
[/sourcecode]
No comments:
Post a Comment