Monday 15 September 2014

generating and running index definitions in oracle

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: