2009년 4월 30일 목요일

10g Flashback Version Query

SQL> create table rates (
2 currency varchar2(4),
3 rate number(15,10)
4 );

테이블이 생성되었습니다.

SQL> insert into rates values ('EURO',1.1012);

1 개의 행이 만들어졌습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> update rates set rate = 1.1014;

1 행이 갱신되었습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> update rates set rate = 1.1013;

1 행이 갱신되었습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> delete rates;

1 행이 삭제되었습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> insert into rates values ('EURO',1.1016);

1 개의 행이 만들어졌습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> update rates set rate = 1.1011;

1 행이 갱신되었습니다.

SQL> commit;

커밋이 완료되었습니다.

SQL> select * from rates;

CURR RATE
---- ----------
EURO 1.1011

SQL> col VERSIONS_STARTTIMe for a18
SQL> col VERSIONS_ENDTIME for a18

SQL> select versions_starttime, versions_endtime, versions_xid, versions_operation, rate
2 from rates versions between timestamp minvalue and maxvalue
3* order by VERSIONS_STARTTIME ;

VERSIONS_STARTTIME VERSIONS_ENDTIME VERSIONS_XID V RATE
------------------ ------------------ ---------------- - ----------
09/04/30 21:55:42 09/04/30 21:56:06 0009000F000B0C4C I 1.1012
09/04/30 21:56:06 09/04/30 21:56:12 00090024000B0B89 U 1.1014
09/04/30 21:56:12 09/04/30 21:56:30 0008000A000C0FCD U 1.1013
09/04/30 21:56:30 00080020000C11ED D 1.1013
09/04/30 21:56:42 09/04/30 21:56:58 00080018000C0D63 I 1.1016
09/04/30 21:56:58 000400090009A1B8 U 1.1011

6 개의 행이 선택되었습니다.

SQL> conn / as sysdba
연결되었습니다.
SQL> grant select any transaction to scott;

권한이 부여되었습니다.

SQL> conn scott/*****

SQL> select undo_sql
2 from flashback_transaction_query
3 where xid='0009000F000B0C4C';

-----------------------------------------------------------------------
insertinto "ANANDA"."RATES"("CURRENCY","RATE")values ('EURO','1.1013');

SQL> select rate, versions_starttime, versions_endtime
2 from rates versions between timestamp to_date(...) and to_date(...)
3* order by VERSIONS_STARTTIME ;

RATE VERSIONS_STARTTIME VERSIONS_ENDTIME
---------- ---------------------- ----------------------
1.1011

10g flashback table

show recyclebin
flashback table table_name to before drop;
purge recyclebin
drop table table_name purge;

2009년 4월 23일 목요일

OPATCH DOWNLOAD

ACTION PLAN
===========
OPATCH 를 다시 다운로드 받으셔서 재설치해 주시기 바랍니다.

To determine if a one-off/patch is available from MetaLink:
a) Click on Patches.
b) Click on Simple Search.
c) Enter patch#: 6880880
d) Select your O/S <=== OS 선택을 해주세요.
e) Click Go.

이후 Version 에 맞는 OPATCH 로 다운로드 받으시면 되겠습니다.


# 참고로 OPATCH 번호는 아래의 노트에서 확인하실 수 있습니다.
< Note.224346.1 : Opatch - Where Can I Find the Latest Version of Opatch? >

opatch info. link

http://blog.naver.com/gosu250?Redirect=Log&logNo=140009762632

systemstate dump

Oracle Issue 발생시에는 systemstate dump 를 통해 해당 서버의 상황을 볼 수 있도록 수행
.
SQL> alter session set events 'immediate trace name systemstate, level 10';
..........약 1분 뒤 ...........
SQL> alter session set events 'immediate trace name systemstate, level 10';

2009년 4월 3일 금요일

local index

--1
CREATE INDEX IDX_PWM_AMLCOD_PNDYMD ON HDDPI_WBL_MTR2 (PWM_AML_COD,PWM_PND_YMD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--2
CREATE INDEX IDX_PWM_DLV_YMD ON HDDPI_WBL_MTR2 (PWM_DLV_YMD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--3
CREATE INDEX IDX_PWM_FDNYMD_DLVCOD ON HDDPI_WBL_MTR2 (PWM_FDN_YMD,PWM_DLV_COD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--4
CREATE INDEX IDX_PWM_INV_NO1 ON HDDPI_WBL_MTR2 (PWM_INV_NO1) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--5
CREATE INDEX IDX_PWM_INV_NO2 ON HDDPI_WBL_MTR2 (PWM_INV_NO2) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--6
CREATE INDEX IDX_PWM_INV_NO3 ON HDDPI_WBL_MTR2 (PWM_INV_NO3) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--7
CREATE INDEX IDX_PWM_NOWSTA_DLVCOD ON HDDPI_WBL_MTR2 (PWM_NOW_STA,PWM_DLV_COD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--8
CREATE INDEX IDX_PWM_NOW_ORG ON HDDPI_WBL_MTR2 (PWM_NOW_ORG) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--9
CREATE INDEX IDX_PWM_PNDYMD_DMLCOD ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_DML_COD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--10
CREATE INDEX IDX_PWM_PNDYMD_INVNO1 ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_INV_NO1) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--11
CREATE INDEX IDX_PWM_PNDYMD_PICCOD ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_PIC_COD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--12
CREATE INDEX IDX_PWM_PNDYMD_RCVNAM ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_RCV_NAM) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--13
CREATE INDEX IDX_PWM_PNDYMD_RCVTEL ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_RCV_TEL) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--14
CREATE INDEX IDX_PWM_PNDYMD_REQNUM ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_REQ_NUM) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--15
CREATE INDEX IDX_PWM_PNDYMD_SNDNAM ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_SND_NAM) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--16
CREATE INDEX IDX_PWM_PNDYMD_SNDTEL ON HDDPI_WBL_MTR2 (PWM_PND_YMD,PWM_SND_TEL) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--17
CREATE INDEX IDX_PWM_RCVNUM_SNDFNO ON HDDPI_WBL_MTR2 (PWM_RCV_NUM,PWM_SND_FNO) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--18
CREATE INDEX IDX_PWM_RSV_NUM ON HDDPI_WBL_MTR2 (PWM_RSV_NUM) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--19
CREATE INDEX IDX_PWM_SDNYMD_DLVCOD ON HDDPI_WBL_MTR2 (PWM_SDN_YMD,PWM_DLV_COD) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--20
CREATE INDEX IDX_PWM_SNDNUM_SNDFNO ON HDDPI_WBL_MTR2 (PWM_SND_NUM,PWM_SND_FNO) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;
--21
CREATE INDEX IDX_PWM_WRKYMD_NOWORG ON HDDPI_WBL_MTR2 (PWM_WRK_YMD,PWM_NOW_ORG) LOCAL (
partition part_mtr_i0000 tablespace TS_AA_WBL_MTR_ORG_I,
partition part_mtr_i0001 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0002 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0003 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0004 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0005 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0006 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0007 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0008 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0009 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0010 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0011 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0012 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0101 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0102 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0103 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0104 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0105 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0106 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0107 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0108 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0109 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0110 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0111 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0112 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0201 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0202 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0203 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0204 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0205 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0206 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0207 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0208 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0209 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0210 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0211 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0212 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0301 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0302 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0303 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0304 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0305 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0306 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0307 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0308 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0309 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0310 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0311 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0312 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0401 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0402 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0403 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0404 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0405 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0406 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0407 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0408 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0409 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0410 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0411 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0412 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0501 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0502 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0503 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0504 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0505 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0506 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0507 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0508 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0509 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0510 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0511 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0512 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0601 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0602 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0603 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0604 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0605 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0606 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0607 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0608 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0609 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0610 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0611 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0612 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0701 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0702 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0703 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0704 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0705 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0706 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0707 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0708 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0709 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0710 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0711 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0712 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0801 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0802 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0803 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0804 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0805 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0806 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0807 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0808 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0809 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0810 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0811 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0812 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i0901 tablespace TS_YY_WBL_MTR_I01,
partition part_mtr_i0902 tablespace TS_YY_WBL_MTR_I02,
partition part_mtr_i0903 tablespace TS_YY_WBL_MTR_I03,
partition part_mtr_i0904 tablespace TS_YY_WBL_MTR_I04,
partition part_mtr_i0905 tablespace TS_YY_WBL_MTR_I05,
partition part_mtr_i0906 tablespace TS_YY_WBL_MTR_I06,
partition part_mtr_i0907 tablespace TS_YY_WBL_MTR_I07,
partition part_mtr_i0908 tablespace TS_YY_WBL_MTR_I08,
partition part_mtr_i0909 tablespace TS_YY_WBL_MTR_I09,
partition part_mtr_i0910 tablespace TS_YY_WBL_MTR_I10,
partition part_mtr_i0911 tablespace TS_YY_WBL_MTR_I11,
partition part_mtr_i0912 tablespace TS_YY_WBL_MTR_I12,
partition part_mtr_i9999 tablespace TS_AA_WBL_MTR_ORG_I
) ;