Plan hash value: 1999981069 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 28T| 4914T| | 85G (79)|398:59:40 | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10019 | 28T| 4914T| | 85G (79)|398:59:40 | | | Q1,19 | P->S | QC (RAND) | |* 3 | FILTER | | | | | | | | | Q1,19 | PCWC | | | 4 | HASH GROUP BY | | 28T| 4914T| 99P| 85G (79)|398:59:40 | | | Q1,19 | PCWP | | | 5 | PX RECEIVE | | 562T| 95P| | 11G (3)| 55:56:24 | | | Q1,19 | PCWP | | | 6 | PX SEND HASH | :TQ10018 | 562T| 95P| | 11G (3)| 55:56:24 | | | Q1,18 | P->P | HASH | | 7 | MERGE JOIN CARTESIAN | | 562T| 95P| | 11G (3)| 55:56:24 | | | Q1,18 | PCWP | | | 8 | MERGE JOIN CARTESIAN | | 168M| 30G| | 279K (1)| 00:00:05 | | | Q1,18 | PCWP | | |* 9 | HASH JOIN | | 2245K| 411M| | 138K (1)| 00:00:03 | | | Q1,18 | PCWP | | | 10 | PX RECEIVE | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,18 | PCWP | | | 11 | PX SEND HASH | :TQ10014 | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,14 | P->P | HASH | | 12 | PX BLOCK ITERATOR | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,14 | PCWC | | | 13 | INDEX STORAGE FAST FULL SCAN | MATERIALSALESDIM_PK | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,14 | PCWP | | | 14 | BUFFER SORT | | | | | | | | | Q1,18 | PCWC | | | 15 | PX RECEIVE | | 2245K| 396M| | 138K (1)| 00:00:03 | | | Q1,18 | PCWP | | | 16 | PX SEND HASH | :TQ10015 | 2245K| 396M| | 138K (1)| 00:00:03 | | | Q1,15 | P->P | HASH | |* 17 | HASH JOIN | | 2245K| 396M| | 138K (1)| 00:00:03 | | | Q1,15 | PCWP | | | 18 | PX RECEIVE | | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,15 | PCWP | | | 19 | PX SEND HASH | :TQ10011 | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,11 | P->P | HASH | | 20 | PX BLOCK ITERATOR | | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,11 | PCWC | | |* 21 | INDEX FAST FULL SCAN | CUSTOMER_X4 | 1159K| 12M| | 159 (4)| 00:00:01 | | | Q1,11 | PCWP | | | 22 | BUFFER SORT | | | | | | | | | Q1,15 | PCWC | | | 23 | PX RECEIVE | | 2245K| 372M| | 138K (1)| 00:00:03 | | | Q1,15 | PCWP | | | 24 | PX SEND HASH | :TQ10012 | 2245K| 372M| | 138K (1)| 00:00:03 | | | Q1,12 | P->P | HASH | |* 25 | HASH JOIN | | 2245K| 372M| | 138K (1)| 00:00:03 | | | Q1,12 | PCWP | | | 26 | PX RECEIVE | | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,12 | PCWP | | | 27 | PX SEND HASH | :TQ10009 | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,09 | P->P | HASH | | 28 | PX BLOCK ITERATOR | | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,09 | PCWC | | |* 29 | INDEX FAST FULL SCAN | MATERIALDIM_X4 | 1588K| 19M| | 260 (2)| 00:00:01 | | | Q1,09 | PCWP | | | 30 | BUFFER SORT | | | | | | | | | Q1,12 | PCWC | | | 31 | PX RECEIVE | | 2245K| 344M| | 138K (1)| 00:00:03 | | | Q1,12 | PCWP | | | 32 | PX SEND HASH | :TQ10010 | 2245K| 344M| | 138K (1)| 00:00:03 | | | Q1,10 | P->P | HASH | |* 33 | HASH JOIN | | 2245K| 344M| | 138K (1)| 00:00:03 | | | Q1,10 | PCWP | | | 34 | PX RECEIVE | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,10 | PCWP | | | 35 | PX SEND HASH | :TQ10007 | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | P->P | HASH | | 36 | PX BLOCK ITERATOR | | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | PCWC | | | 37 | INDEX STORAGE FAST FULL SCAN | CUSTOMER_PK | 3341K| 22M| | 148 (2)| 00:00:01 | | | Q1,07 | PCWP | | | 38 | BUFFER SORT | | | | | | | | | Q1,10 | PCWC | | | 39 | PX RECEIVE | | 2245K| 329M| | 138K (1)| 00:00:03 | | | Q1,10 | PCWP | | | 40 | PX SEND HASH | :TQ10008 | 2245K| 329M| | 138K (1)| 00:00:03 | | | Q1,08 | P->P | HASH | |* 41 | HASH JOIN | | 2245K| 329M| | 138K (1)| 00:00:03 | | | Q1,08 | PCWP | | | 42 | PX RECEIVE | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,08 | PCWP | | | 43 | PX SEND HASH | :TQ10005 | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | P->P | HASH | | 44 | PX BLOCK ITERATOR | | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | PCWC | | | 45 | INDEX STORAGE FAST FULL SCAN | MATERIALSALESDIM_PK | 1167K| 7980K| | 51 (0)| 00:00:01 | | | Q1,05 | PCWP | | | 46 | BUFFER SORT | | | | | | | | | Q1,08 | PCWC | | | 47 | PX RECEIVE | | 2245K| 314M| | 138K (1)| 00:00:03 | | | Q1,08 | PCWP | | | 48 | PX SEND HASH | :TQ10006 | 2245K| 314M| | 138K (1)| 00:00:03 | | | Q1,06 | P->P | HASH | |* 49 | HASH JOIN | | 2245K| 314M| | 138K (1)| 00:00:03 | | | Q1,06 | PCWP | | | 50 | PX RECEIVE | | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,06 | PCWP | | | 51 | PX SEND BROADCAST | :TQ10002 | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,02 | P->P | BROADCAST | | 52 | PX BLOCK ITERATOR | | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,02 | PCWC | | |* 53 | TABLE ACCESS STORAGE FULL | TIMEDIM_MONTH | 127 | 1651 | | 2 (0)| 00:00:01 | | | Q1,02 | PCWP | | |* 54 | HASH JOIN | | 2640K| 337M| | 138K (1)| 00:00:03 | | | Q1,06 | PCWP | | | 55 | PX RECEIVE | | 1588K| 30M| | 2445 (1)| 00:00:01 | | | Q1,06 | PCWP | | | 56 | PX SEND HASH | :TQ10003 | 1588K| 30M| | 2445 (1)| 00:00:01 | | | Q1,03 | P->P | HASH | | 57 | PX BLOCK ITERATOR | | 1588K| 30M| | 2445 (1)| 00:00:01 | | | Q1,03 | PCWC | | | 58 | TABLE ACCESS STORAGE FULL | MATERIALDIM | 1588K| 30M| | 2445 (1)| 00:00:01 | | | Q1,03 | PCWP | | | 59 | BUFFER SORT | | | | | | | | | Q1,06 | PCWC | | | 60 | PX RECEIVE | | 2640K| 287M| | 135K (1)| 00:00:03 | | | Q1,06 | PCWP | | | 61 | PX SEND HASH | :TQ10004 | 2640K| 287M| | 135K (1)| 00:00:03 | | | Q1,04 | P->P | HASH | |* 62 | HASH JOIN | | 2640K| 287M| | 135K (1)| 00:00:03 | | | Q1,04 | PCWP | | | 63 | PX RECEIVE | | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,04 | PCWP | | | 64 | PX SEND BROADCAST | :TQ10000 | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,00 | P->P | BROADCAST | | 65 | PX BLOCK ITERATOR | | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,00 | PCWC | | | 66 | L SCAN INDEX STORAGE FAST FUL | USAGEOPTIONSDIM_PK | 28075 | 191K| | 2 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 67 | HASH JOIN | | 2640K| 269M| | 135K (1)| 00:00:03 | | | Q1,04 | PCWP | | | 68 | PX RECEIVE | | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,04 | PCWP | | | 69 | PX SEND BROADCAST | :TQ10001 | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,01 | P->P | BROADCAST | | 70 | PX BLOCK ITERATOR | | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,01 | PCWC | | |* 71 | FULL TABLE ACCESS STORAGE | CUSTOMER | 115K| 1350K| | 7618 (1)| 00:00:01 | | | Q1,01 | PCWP | | | 72 | NESTED LOOPS | | | | | | | | | Q1,04 | PCWP | | | 73 | NESTED LOOPS | | 9039K| 818M| | 127K (1)| 00:00:03 | | | Q1,04 | PCWP | | | 74 | PX BLOCK ITERATOR | | | | | | | | | Q1,04 | PCWC | | |* 75 | INDEX FAST FULL SCAN | MATERIALDIM_X4 | 102 | 1326 | | 289 (12)| 00:00:01 | | | Q1,04 | PCWP | | | 76 | PARTITION LIST ALL | | | | | | | 1 | 156 | Q1,04 | PCWP | | | 77 | ROWIDS BITMAP CONVERSION TO | | | | | | | | | Q1,04 | PCWP | | |* 78 | VALUE BITMAP INDEX SINGLE | WLR_CUST_DB_MTH_BX4 | | | | | | 1 | 156 | Q1,04 | PCWP | | | 79 | NDEX ROWID TABLE ACCESS BY LOCAL I | WLR_CUST_DB_MTH | 88868 | 7116K| | 127K (1)| 00:00:03 | 1 | 1 | Q1,04 | PCWP | | | 80 | BUFFER SORT | | 75 | | | 279K (1)| 00:00:05 | | | Q1,18 | PCWP | | | 81 | PX RECEIVE | | 75 | | | | | | | Q1,18 | PCWP | | | 82 | PX SEND BROADCAST | :TQ10016 | 75 | | | | | | | Q1,16 | P->P | BROADCAST | | 83 | VIEW | | 75 | | | | | | | Q1,16 | PCWP | | | 84 | HASH UNIQUE | | 75 | 675 | | 3 (34)| 00:00:01 | | | Q1,16 | PCWP | | | 85 | PX RECEIVE | | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,16 | PCWP | | | 86 | PX SEND HASH | :TQ10013 | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,13 | P->P | HASH | | 87 | PX BLOCK ITERATOR | | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,13 | PCWC | | |* 88 | TABLE ACCESS STORAGE FULL | TIMEDIM_MONTH | 75 | 675 | | 2 (0)| 00:00:01 | | | Q1,13 | PCWP | | | 89 | BUFFER SORT | | 3341K| | | 85G (79)|398:59:40 | | | Q1,18 | PCWP | | | 90 | PX RECEIVE | | 3341K| | | 148 (2)| 00:00:01 | | | Q1,18 | PCWP | | | 91 | PX SEND BROADCAST | :TQ10017 | 3341K| | | 148 (2)| 00:00:01 | | | Q1,17 | P->P | BROADCAST | | 92 | PX BLOCK ITERATOR | | 3341K| | | 148 (2)| 00:00:01 | | | Q1,17 | PCWC | | | 93 | INDEX STORAGE FAST FULL SCAN | CUSTOMER_PK | 3341K| | | 148 (2)| 00:00:01 | | | Q1,17 | PCWP | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - filter(SUM("WLR_CUST_DB_MTH"."ZNWSALE")+SUM("WLR_CUST_DB_MTH"."ZSALE")+SUM("WLR_CUST_DB_MTH"."ZUPGSALE")-(SUM("WLR_CUST_DB_MTH"."ZNWRET")+SUM("WLR_CUST_DB_MTH"."ZRET")+SU M("WLR_CUST_DB_MTH"."ZUPGRET"))<>0) 9 - access("WLR_CUST_DB_MTH"."DB_MAT_SALES_KEY"="DB_MATSALESDIM"."MATERIAL_SALES_KEY") 17 - access("WLR_CUST_DB_MTH"."SOLD_TO"="CUSTOMERSP"."CUSTOMER_KEY") 21 - filter("CUSTOMERSP"."INDUSTRY"<>'PWI' AND "CUSTOMERSP"."INDUSTRY"<>'AWI' AND "CUSTOMERSP"."INDUSTRY"<>'CWI' AND "CUSTOMERSP"."INDUSTRY"<>'FGWI' AND "CUSTOMERSP"."INDUSTRY"<>'FWI' AND "CUSTOMERSP"."INDUSTRY"<>'GWI') 25 - access("WLR_CUST_DB_MTH"."CLASS_MAT_KEY"="CLASS_MATDIM"."MATERIAL_KEY") 29 - filter("CLASS_MATDIM"."MATERIAL_NUM"<>30004517 AND "CLASS_MATDIM"."MATERIAL_NUM"<>33000003 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40434827 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40544038 AND "CLASS_MATDIM"."MATERIAL_NUM"<>40697050) 33 - access("WLR_CUST_DB_MTH"."ZWL_RPT_ORG"="CUSTOMERZW"."CUSTOMER_KEY") 41 - access("WLR_CUST_DB_MTH"."SUB_MAT_SALES_KEY"="SUB_MATSALESDIM"."MATERIAL_SALES_KEY") 49 - access("TIME_DIM_KEY"="WLR_CUST_DB_MTH"."CALDAY") 53 - storage("MONTH_NUMERIC">='201201' AND "TD"."MONTH_NUMERIC"<>'NV') filter("MONTH_NUMERIC">='201201' AND "TD"."MONTH_NUMERIC"<>'NV') 54 - access("WLR_CUST_DB_MTH"."DB_MAT_KEY"="DB_MATDIM"."MATERIAL_KEY") 62 - access("WLR_CUST_DB_MTH"."USAGEOPTIONDIM_KEY"="USAGEOPTIONSDIM"."USAGEOPTIONDIM_KEY") 67 - access("WLR_CUST_DB_MTH"."ZWL_SUB_LOC"="CUSTOMERZB"."CUSTOMER_KEY") 71 - storage("CUSTOMERZB"."SALESORG"='WEST') filter("CUSTOMERZB"."SALESORG"='WEST') 75 - filter("SUB_MATDIM"."MATERIAL_NUM"=40884735 OR "SUB_MATDIM"."MATERIAL_NUM"=40887249 OR "SUB_MATDIM"."MATERIAL_NUM"=40902546 OR "SUB_MATDIM"."MATERIAL_NUM"=40902548 OR "SUB_MATDIM"."MATERIAL_NUM"=40902640 OR "SUB_MATDIM"."MATERIAL_NUM"=40902852 OR "SUB_MATDIM"."MATERIAL_NUM"=40902872 OR "SUB_MATDIM"."MATERIAL_NUM"=40902875 OR "SUB_MATDIM"."MATERIAL_NUM"=40905196 OR "SUB_MATDIM"."MATERIAL_NUM"=40905198 OR "SUB_MATDIM"."MATERIAL_NUM"=40905205 OR "SUB_MATDIM"."MATERIAL_NUM"=40905207 OR "SUB_MATDIM"."MATERIAL_NUM"=40905374 OR "SUB_MATDIM"."MATERIAL_NUM"=40905376 OR "SUB_MATDIM"."MATERIAL_NUM"=40905544 OR "SUB_MATDIM"."MATERIAL_NUM"=40905546 OR "SUB_MATDIM"."MATERIAL_NUM"=40972051 OR "SUB_MATDIM"."MATERIAL_NUM"=40972053 OR "SUB_MATDIM"."MATERIAL_NUM"=40976376 OR "SUB_MATDIM"."MATERIAL_NUM"=40976378 OR "SUB_MATDIM"."MATERIAL_NUM"=40986780 OR "SUB_MATDIM"."MATERIAL_NUM"=40986885 OR "SUB_MATDIM"."MATERIAL_NUM"=40987332 OR "SUB_MATDIM"."MATERIAL_NUM"=40987897 OR "SUB_MATDIM"."MATERIAL_NUM"=40988801 OR "SUB_MATDIM"."MATERIAL_NUM"=40988829 OR "SUB_MATDIM"."MATERIAL_NUM"=40989491 OR "SUB_MATDIM"."MATERIAL_NUM"=40989523 OR "SUB_MATDIM"."MATERIAL_NUM"=40990064 OR "SUB_MATDIM"."MATERIAL_NUM"=40990648 OR "SUB_MATDIM"."MATERIAL_NUM"=40990848 OR "SUB_MATDIM"."MATERIAL_NUM"=40992145 OR "SUB_MATDIM"."MATERIAL_NUM"=41016776 OR "SUB_MATDIM"."MATERIAL_NUM"=41016779 OR "SUB_MATDIM"."MATERIAL_NUM"=41018514 OR "SUB_MATDIM"."MATERIAL_NUM"=41018517 OR "SUB_MATDIM"."MATERIAL_NUM"=41026449 OR "SUB_MATDIM"."MATERIAL_NUM"=41026512 OR "SUB_MATDIM"."MATERIAL_NUM"=41026767 OR "SUB_MATDIM"."MATERIAL_NUM"=41026770 OR "SUB_MATDIM"."MATERIAL_NUM"=41026777 OR "SUB_MATDIM"."MATERIAL_NUM"=41026806 OR "SUB_MATDIM"."MATERIAL_NUM"=41026883 OR "SUB_MATDIM"."MATERIAL_NUM"=41026929 OR "SUB_MATDIM"."MATERIAL_NUM"=41027434 OR "SUB_MATDIM"."MATERIAL_NUM"=41029592 OR "SUB_MATDIM"."MATERIAL_NUM"=41054553 OR "SUB_MATDIM"."MATERIAL_NUM"=41054555 OR "SUB_MATDIM"."MATERIAL_NUM"=41054847 OR "SUB_MATDIM"."MATERIAL_NUM"=41058222 OR "SUB_MATDIM"."MATERIAL_NUM"=41059767 OR "SUB_MATDIM"."MATERIAL_NUM"=41059768 OR "SUB_MATDIM"."MATERIAL_NUM"=41059965 OR "SUB_MATDIM"."MATERIAL_NUM"=41059966 OR "SUB_MATDIM"."MATERIAL_NUM"=41098654 OR "SUB_MATDIM"."MATERIAL_NUM"=41098656 OR "SUB_MATDIM"."MATERIAL_NUM"=41169613 OR "SUB_MATDIM"."MATERIAL_NUM"=41169615 OR "SUB_MATDIM"."MATERIAL_NUM"=41169617 OR "SUB_MATDIM"."MATERIAL_NUM"=41169619 OR "SUB_MATDIM"."MATERIAL_NUM"=41169684 OR "SUB_MATDIM"."MATERIAL_NUM"=41169685 OR "SUB_MATDIM"."MATERIAL_NUM"=41169689 OR "SUB_MATDIM"."MATERIAL_NUM"=41169861 OR "SUB_MATDIM"."MATERIAL_NUM"=41169863 OR "SUB_MATDIM"."MATERIAL_NUM"=41169865 OR "SUB_MATDIM"."MATERIAL_NUM"=41169867 OR "SUB_MATDIM"."MATERIAL_NUM"=41169869 OR "SUB_MATDIM"."MATERIAL_NUM"=41170053 OR "SUB_MATDIM"."MATERIAL_NUM"=41170055 OR "SUB_MATDIM"."MATERIAL_NUM"=41170057 OR "SUB_MATDIM"."MATERIAL_NUM"=41170741 OR "SUB_MATDIM"."MATERIAL_NUM"=41170744 OR "SUB_MATDIM"."MATERIAL_NUM"=41170800 OR "SUB_MATDIM"."MATERIAL_NUM"=41170842 OR "SUB_MATDIM"."MATERIAL_NUM"=41170846 OR "SUB_MATDIM"."MATERIAL_NUM"=41170848 OR "SUB_MATDIM"."MATERIAL_NUM"=41170850 OR "SUB_MATDIM"."MATERIAL_NUM"=41170942 OR "SUB_MATDIM"."MATERIAL_NUM"=41170944 OR "SUB_MATDIM"."MATERIAL_NUM"=41172924 OR "SUB_MATDIM"."MATERIAL_NUM"=41173655 OR "SUB_MATDIM"."MATERIAL_NUM"=41176487 OR "SUB_MATDIM"."MATERIAL_NUM"=41176692 OR "SUB_MATDIM"."MATERIAL_NUM"=41191390 OR "SUB_MATDIM"."MATERIAL_NUM"=41191412 OR "SUB_MATDIM"."MATERIAL_NUM"=41191607 OR "SUB_MATDIM"."MATERIAL_NUM"=41191609 OR "SUB_MATDIM"."MATERIAL_NUM"=41191651 OR "SUB_MATDIM"."MATERIAL_NUM"=41206779 OR "SUB_MATDIM"."MATERIAL_NUM"=41207131 OR "SUB_MATDIM"."MATERIAL_NUM"=41207133 OR "SUB_MATDIM"."MATERIAL_NUM"=41207674 OR "SUB_MATDIM"."MATERIAL_NUM"=41207677 OR "SUB_MATDIM"."MATERIAL_NUM"=41207679 OR "SUB_MATDIM"."MATERIAL_NUM"=41207774 OR "SUB_MATDIM"."MATERIAL_NUM"=41208072 OR "SUB_MATDIM"."MATERIAL_NUM"=41208074 OR "SUB_MATDIM"."MATERIAL_NUM"=41208721 OR "SUB_MATDIM"."MATERIAL_NUM"=41208723 OR) 78 - access("WLR_CUST_DB_MTH"."SUB_MAT_KEY"="SUB_MATDIM"."MATERIAL_KEY") 88 - storage("WLU_812_FLAG"='Y') filter("WLU_812_FLAG"='Y') DDL /* Formatted on 6/21/2012 11:36:07 AM (QP5 v5.215.12089.38647) */ /* Formatted on 6/21/2012 11:37:51 AM (QP5 v5.215.12089.38647) */ CREATE TABLE "TRDW"."WLR_CUST_DB_MTH" ( "WLR_CUSTDBMTH_KEY" NUMBER (19, 0) NOT NULL ENABLE, "CALDAY" NUMBER (10, 0) NOT NULL ENABLE, "ZWL_SUB_LOC" NUMBER (10, 0) NOT NULL ENABLE, "DB_MAT_SALES_KEY" NUMBER (10, 0) NOT NULL ENABLE, "DB_MAT_KEY" NUMBER (10, 0) NOT NULL ENABLE, "CLASS_MAT_SALES_KE" NUMBER (10, 0) NOT NULL ENABLE, "CLASS_MAT_KEY" NUMBER (10, 0) NOT NULL ENABLE, "SUB_MAT_KEY" NUMBER (10, 0) NOT NULL ENABLE, "SUB_MAT_SALES_KEY" NUMBER (10, 0) NOT NULL ENABLE, "ZWL_RPT_ORG" NUMBER (10, 0) NOT NULL ENABLE, "ZWL_PAY_GRP" NUMBER (10, 0) NOT NULL ENABLE, "SOLD_TO" NUMBER (10, 0) NOT NULL ENABLE, "BILL_TO" NUMBER (10, 0) NOT NULL ENABLE, "SHIP_TO" NUMBER (10, 0) NOT NULL ENABLE, "PAYER" NUMBER (10, 0) NOT NULL ENABLE, "ZCUST_ORG" NUMBER (10, 0) NOT NULL ENABLE, "ZWL_USG_GRP" NUMBER (10, 0) NOT NULL ENABLE, "ZSTATE_LST" NUMBER (10, 0) NOT NULL ENABLE, "ZWL_BILL_TO" NUMBER (10, 0) NOT NULL ENABLE, "TACT_SUB_LOC" NUMBER (10, 0) NOT NULL ENABLE, "TACT_RPT_ORG" NUMBER (10, 0) NOT NULL ENABLE, "USAGEPLATDIM_KEY" NUMBER (10, 0) NOT NULL ENABLE, "USAGEOPTIONDIM_KEY" NUMBER (10, 0) NOT NULL ENABLE, "CUSTOMER_HISTDIM_KEY" NUMBER (10, 0) NOT NULL ENABLE, "MATERIAL_HISTDIM_KEY" NUMBER (10, 0) NOT NULL ENABLE, "WL_VENDOR_ID" VARCHAR2 (3 CHAR), "TACT_PROMO_NUM" VARCHAR2 (10 CHAR), "TACT_USG_TYPE" VARCHAR2 (3 CHAR), "ZFRSECS" NUMBER (10, 0), "ZCNCHSECS" NUMBER (10, 0), "ZSESSCNT" NUMBER (10, 3), "ZCHSECS" NUMBER (10, 0), "ZCNFRSECS" NUMBER (10, 0), "ZCMCHSECS" NUMBER (10, 0), "ZCMFRSECS" NUMBER (10, 0), "ZCHTRANS" NUMBER (10, 0), "ZFRTRANS" NUMBER (10, 0), "ZCHLINES" NUMBER (10, 0), "ZFRLINES" NUMBER (10, 0), "ZCHDOCS" NUMBER (10, 0), "ZFRDOCS" NUMBER (10, 0), "ZCHIMAGES" NUMBER (10, 0), "ZFRIMAGES" NUMBER (10, 0), "ZRPTLINES" NUMBER (10, 0), "ZRPTDOCS" NUMBER (10, 0), "ZRPTPAGES" NUMBER (10, 0), "ZREGVCHRG" NUMBER (17, 2), "ZACTCHRG" NUMBER (17, 2), "ZACTADJ" NUMBER (17, 2), "ZNWSALE" NUMBER (17, 2), "ZNWRET" NUMBER (17, 2), "ZSALE" NUMBER (17, 2), "ZRET" NUMBER (17, 2), "ZUPGSALE" NUMBER (17, 2), "ZUPGRET" NUMBER (17, 2), "UPDATE_TIMESTAMP" DATE, "SECURITY_ID" NUMBER (5, 0), "USAGEMISCDIM_KEY" NUMBER (10, 0), "NAT_CURR_CODE" VARCHAR2 (5 CHAR), "NAT_EXCHANGE_RATE" NUMBER (15, 10), "CUST_SALES" NUMBER (11, 2), "CUST_RETURNS" NUMBER (11, 2), "SDEF_IND" VARCHAR2 (3 CHAR), "SDEF_CHRG" NUMBER (11, 2), "NAT_TOT_NET" NUMBER (17, 2), "USAGEPROMODIM_KEY" NUMBER (10, 0), "PART_CNT" NUMBER (10, 0), "TRAN_CNT" NUMBER (10, 0) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE (INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" PARTITION BY LIST ("CALDAY") (PARTITION "P20000101" VALUES (20000101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000201" VALUES (20000201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000301" VALUES (20000301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000401" VALUES (20000401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000501" VALUES (20000501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000601" VALUES (20000601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000701" VALUES (20000701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000801" VALUES (20000801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20000901" VALUES (20000901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20001001" VALUES (20001001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20001101" VALUES (20001101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20001201" VALUES (20001201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010101" VALUES (20010101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010201" VALUES (20010201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010301" VALUES (20010301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010401" VALUES (20010401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010501" VALUES (20010501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010601" VALUES (20010601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010701" VALUES (20010701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010801" VALUES (20010801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20010901" VALUES (20010901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20011001" VALUES (20011001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20011101" VALUES (20011101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20011201" VALUES (20011201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020101" VALUES (20020101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020201" VALUES (20020201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020301" VALUES (20020301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020401" VALUES (20020401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020501" VALUES (20020501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020601" VALUES (20020601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020701" VALUES (20020701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020801" VALUES (20020801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20020901" VALUES (20020901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20021001" VALUES (20021001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20021101" VALUES (20021101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20021201" VALUES (20021201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030101" VALUES (20030101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030201" VALUES (20030201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030301" VALUES (20030301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030401" VALUES (20030401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030501" VALUES (20030501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030601" VALUES (20030601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030701" VALUES (20030701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030801" VALUES (20030801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20030901" VALUES (20030901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20031001" VALUES (20031001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20031101" VALUES (20031101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20031201" VALUES (20031201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040101" VALUES (20040101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040201" VALUES (20040201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040301" VALUES (20040301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040401" VALUES (20040401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040501" VALUES (20040501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040601" VALUES (20040601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040701" VALUES (20040701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040801" VALUES (20040801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20040901" VALUES (20040901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20041001" VALUES (20041001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20041101" VALUES (20041101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20041201" VALUES (20041201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050101" VALUES (20050101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050201" VALUES (20050201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050301" VALUES (20050301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050401" VALUES (20050401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050501" VALUES (20050501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050601" VALUES (20050601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050701" VALUES (20050701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050801" VALUES (20050801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20050901" VALUES (20050901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20051001" VALUES (20051001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20051101" VALUES (20051101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20051201" VALUES (20051201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060101" VALUES (20060101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060201" VALUES (20060201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060301" VALUES (20060301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060401" VALUES (20060401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060501" VALUES (20060501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060601" VALUES (20060601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060701" VALUES (20060701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060801" VALUES (20060801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20060901" VALUES (20060901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20061001" VALUES (20061001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20061101" VALUES (20061101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20061201" VALUES (20061201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070101" VALUES (20070101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070201" VALUES (20070201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070301" VALUES (20070301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070401" VALUES (20070401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070501" VALUES (20070501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070601" VALUES (20070601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070701" VALUES (20070701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070801" VALUES (20070801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20070901" VALUES (20070901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20071001" VALUES (20071001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20071101" VALUES (20071101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20071201" VALUES (20071201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080101" VALUES (20080101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080201" VALUES (20080201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080301" VALUES (20080301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080401" VALUES (20080401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080501" VALUES (20080501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080601" VALUES (20080601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080701" VALUES (20080701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080801" VALUES (20080801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20080901" VALUES (20080901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20081001" VALUES (20081001) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20081101" VALUES (20081101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20081201" VALUES (20081201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090101" VALUES (20090101) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090201" VALUES (20090201) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090301" VALUES (20090301) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090401" VALUES (20090401) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090501" VALUES (20090501) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090601" VALUES (20090601) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090701" VALUES (20090701) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090801" VALUES (20090801) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20090901" VALUES (20090901) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20091001" VALUES (20091001) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20091101" VALUES (20091101) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20091201" VALUES (20091201) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100101" VALUES (20100101) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100201" VALUES (20100201) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100301" VALUES (20100301) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100401" VALUES (20100401) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100501" VALUES (20100501) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100601" VALUES (20100601) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100701" VALUES (20100701) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100801" VALUES (20100801) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20100901" VALUES (20100901) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20101001" VALUES (20101001) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20101101" VALUES (20101101) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20101201" VALUES (20101201) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110101" VALUES (20110101) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110201" VALUES (20110201) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110301" VALUES (20110301) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110401" VALUES (20110401) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110501" VALUES (20110501) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110601" VALUES (20110601) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110701" VALUES (20110701) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110801" VALUES (20110801) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20110901" VALUES (20110901) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20111001" VALUES (20111001) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20111101" VALUES (20111101) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20111201" VALUES (20111201) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE(INITIAL 8388608 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120101" VALUES (20120101) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120201" VALUES (20120201) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120301" VALUES (20120301) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120401" VALUES (20120401) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120501" VALUES (20120501) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120601" VALUES (20120601) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120701" VALUES (20120701) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120801" VALUES (20120801) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20120901" VALUES (20120901) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20121001" VALUES (20121001) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20121101" VALUES (20121101) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" , PARTITION "P20121201" VALUES (20121201) SEGMENT CREATION DEFERRED PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE( INITIAL 8388608 NEXT 8388608 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D105" ) PARALLEL 16 ENABLE ROW MOVEMENT CREATE TABLE "TRDW"."MATERIALDIM" ( "MATERIAL_KEY" NUMBER (10, 0) NOT NULL ENABLE, "BASE_UOM" VARCHAR2 (3 CHAR), "MATERIAL" VARCHAR2 (18 CHAR) NOT NULL ENABLE, "BASIC_MATL" VARCHAR2 (14 CHAR), "CREATEDON" VARCHAR2 (8 CHAR), "MATL_GROUP" VARCHAR2 (9 CHAR), "MATL_TYPE" VARCHAR2 (4 CHAR), "PROD_HIER" VARCHAR2 (18 CHAR), "DEL_FLAG" VARCHAR2 (3 CHAR), "ZADDTOPC1" VARCHAR2 (30 CHAR), "ZADDTOPC2" VARCHAR2 (30 CHAR), "ZADDTOPC3" VARCHAR2 (30 CHAR), "ZDBCHGSTT" VARCHAR2 (2 CHAR), "ZDBCLASS" VARCHAR2 (3 CHAR), "ZDBSIGNON" VARCHAR2 (18 CHAR), "ZOLD_MATL" VARCHAR2 (18 CHAR), "ZPROC_SEQ" VARCHAR2 (2 CHAR), "ZREPLMAT2" VARCHAR2 (30 CHAR), "ZREPLMAT3" VARCHAR2 (30 CHAR), "ZREPLMATL" VARCHAR2 (30 CHAR), "ZRPLCEDBY" VARCHAR2 (18 CHAR), "ZSOFTVERS" VARCHAR2 (4 CHAR), "ZSORTORD" VARCHAR2 (4 CHAR), "PRODHIERLVL1" VARCHAR2 (2 CHAR), "PRODHIERLVL2" VARCHAR2 (2 CHAR), "PRODHIERLVL3" VARCHAR2 (2 CHAR), "PRODHIERLVL4" VARCHAR2 (2 CHAR), "PRODHIERLVL5" VARCHAR2 (2 CHAR), "PRODHIERLVL6" VARCHAR2 (2 CHAR), "DATEFROM" VARCHAR2 (8 CHAR), "UPDATE_TIMESTAMP" DATE, "MATERIAL_TXT" VARCHAR2 (40 CHAR), "MATL_GROUP_TXT" VARCHAR2 (54 CHAR), "MATL_TYPE_TXT" VARCHAR2 (40 CHAR), "PRODHIERLVL1_TXT" VARCHAR2 (20 CHAR), "DBCHSTT_TXT" VARCHAR2 (20 CHAR), "DBCLASS_TXT" VARCHAR2 (54 CHAR), "PRODHIERLVL4_TXT" VARCHAR2 (20 CHAR), "PRODHIERLVL5_TXT" VARCHAR2 (20 CHAR), "PRODHIERLVL6_TXT" VARCHAR2 (20 CHAR), "PRODHIERLVL3_TXT" VARCHAR2 (20 CHAR), "PROC_SEQ_TXT" VARCHAR2 (20 CHAR), "PRODHIERLVL2_TXT" VARCHAR2 (20 CHAR), "ROYALTY_DB_NUM" VARCHAR2 (5 CHAR), "CONTRACT_NUM" VARCHAR2 (18 CHAR), "SUB_MAT_GRP" VARCHAR2 (20 CHAR) NOT NULL ENABLE, "MAT_REV_TYPE" VARCHAR2 (20 CHAR) NOT NULL ENABLE, "MATERIAL_NUM" NUMBER (18, 0), "LABOR_ISM_FLAG" VARCHAR2 (5 CHAR), "MSTAE_XPLANT_MAT_STATUS" VARCHAR2 (2 CHAR), "MSTAE_XPLANT_MAT_STATUS_TXT" VARCHAR2 (40 CHAR), "BRGEW_GROSS_WT" NUMBER (17, 3), "NTGEW_NET_WT" NUMBER (17, 3), "VOLUM_VOLUME" NUMBER (17, 3), "GROES_SIZE_DIM" VARCHAR2 (32 CHAR), "OWNER_DISTR_CHAN" VARCHAR2 (2 CHAR), "OWNER_DISTR_CHAN_TXT" VARCHAR2 (20 CHAR), "OWNER_SALESORG" VARCHAR2 (4 CHAR), "OWNER_SALESORG_TXT" VARCHAR2 (60 CHAR), "OWNER_DOMAIN" VARCHAR2 (15 CHAR), "CH_ON" NUMBER (10, 0), "CHANGEDBY" VARCHAR2 (12 CHAR), "CREATEDBY" VARCHAR2 (12 CHAR), "MFRPN_MFG_PART_NUM_TXT" VARCHAR2 (40 CHAR), "MFRPR_MANUFACTURER" VARCHAR2 (10 CHAR), "EAN11_EAN_NUM" VARCHAR2 (18 CHAR), "NUMTP_EAN_CATEGORY" VARCHAR2 (2 CHAR), "DSPCD_ONL_CHG_PRICE_CD" VARCHAR2 (3 CHAR), "FAMILY_TXT" VARCHAR2 (40 CHAR), "PRO_ALLOCATION" VARCHAR2 (18 CHAR), "ZLENGTH" NUMBER (17, 3), "ZWIDTH" NUMBER (17, 3), "ZHEIGHT" NUMBER (17, 3), "ZEDITION" VARCHAR2 (2 CHAR), "UNIT_DIM" VARCHAR2 (3 CHAR), "PRINT_FAMILY" VARCHAR2 (200 CHAR), "PRINT_GROUPING" VARCHAR2 (200 CHAR), "FINDLAW_CATEGORY" VARCHAR2 (200 CHAR), "FINDLAW_BUSINESS_LINE" VARCHAR2 (200 CHAR), "PRODUCT_PUBLISHER" VARCHAR2 (4 CHAR), "FINDLAW_CATEGORY2" VARCHAR2 (200 CHAR), "ZACTRFLAG_ASSETCENTER_FLAG" VARCHAR2 (1 CHAR), "ZPROFID_PROFILE_ID" VARCHAR2 (4 CHAR), "IND_SECTOR" VARCHAR2 (1 CHAR), "BSTME" VARCHAR2 (3 CHAR), "UNIT_OF_WT" VARCHAR2 (3 CHAR), "ZPACQTY_PAC_QUANTITY" VARCHAR2 (30 CHAR), "MEDIAHL_RULE" VARCHAR2 (2 CHAR), "MEDIALL_RULE" VARCHAR2 (2 CHAR), "VAR_CONFIG_CHAR_IND" VARCHAR2 (1 CHAR), "ORIG_ZCATEGORY" VARCHAR2 (2 CHAR), "ORIG_CATEGORY_TXT" VARCHAR2 (20 CHAR), "ORIG_ZTOPIC" VARCHAR2 (2 CHAR), "ORIG_TOPIC_TXT" VARCHAR2 (20 CHAR), "ORIG_ZPH_CTRY" VARCHAR2 (2 CHAR), "ORIG_PH_CTRY_TXT" VARCHAR2 (20 CHAR), "ORIG_ZJURIS" VARCHAR2 (2 CHAR), "ORIG_JURIS_TXT" VARCHAR2 (20 CHAR), "ORIG_ZMEDIAHL" VARCHAR2 (2 CHAR), "ORIG_MEDIAHL_TXT" VARCHAR2 (20 CHAR), "ORIG_ZMEDIALL" VARCHAR2 (2 CHAR), "ORIG_MEDIALL_TXT" VARCHAR2 (20 CHAR), CONSTRAINT "MATERIALDIM_PK" PRIMARY KEY ("MATERIAL_KEY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" PARALLEL 16 /* Formatted on 6/21/2012 11:36:35 AM (QP5 v5.215.12089.38647) */ CREATE TABLE "TRDW"."TIMEDIM_MONTH" ( "TIME_DIM_KEY" NUMBER (38, 0) NOT NULL ENABLE, "CALENDAR_DATE" VARCHAR2 (10 CHAR), "CALENDAR_DATE_DATE" DATE, "MONTH_NUMERIC" VARCHAR2 (6 CHAR), "TIME_MONTH_NUM" NUMBER (38, 0), "TIME_MONTH_NAME" VARCHAR2 (10 CHAR), "TIME_DAY_NUM" NUMBER (38, 0), "TIME_QUARTER_NUM" NUMBER (38, 0), "TIME_YEAR_NUM" NUMBER (38, 0), "TIME_DAY_OF_WEEK" VARCHAR2 (10 CHAR), "WLU_812_FLAG" VARCHAR2 (3 CHAR), "LOADED_BILLING_FLAG" VARCHAR2 (3 CHAR), "LOADED_CUSTCARE_FLAG" VARCHAR2 (3 CHAR), "LOADED_DELIVERY_FLAG" VARCHAR2 (3 CHAR), "LOADED_ORDERS_FLAG" VARCHAR2 (3 CHAR), "LOADED_SUBS_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLR_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLU_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLXREF_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLY_FLAG" VARCHAR2 (3 CHAR), "LOADED_PRICING_FLAG" VARCHAR2 (3 CHAR), "INFA_COMPLETE_FLAG" VARCHAR2 (3 CHAR), "UPDATE_TIMESTAMP" DATE, "CALENDAR_WEEK_END" VARCHAR2 (10 CHAR), "SHORT_REP_DATE" VARCHAR2 (22 CHAR), CONSTRAINT "TIMEDIM_MONTH_PK" PRIMARY KEY ("TIME_DIM_KEY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" PARALLEL 8 /* Formatted on 6/21/2012 11:37:11 AM (QP5 v5.215.12089.38647) */ CREATE TABLE "TRDW"."TIMEDIM_MONTH" ( "TIME_DIM_KEY" NUMBER (38, 0) NOT NULL ENABLE, "CALENDAR_DATE" VARCHAR2 (10 CHAR), "CALENDAR_DATE_DATE" DATE, "MONTH_NUMERIC" VARCHAR2 (6 CHAR), "TIME_MONTH_NUM" NUMBER (38, 0), "TIME_MONTH_NAME" VARCHAR2 (10 CHAR), "TIME_DAY_NUM" NUMBER (38, 0), "TIME_QUARTER_NUM" NUMBER (38, 0), "TIME_YEAR_NUM" NUMBER (38, 0), "TIME_DAY_OF_WEEK" VARCHAR2 (10 CHAR), "WLU_812_FLAG" VARCHAR2 (3 CHAR), "LOADED_BILLING_FLAG" VARCHAR2 (3 CHAR), "LOADED_CUSTCARE_FLAG" VARCHAR2 (3 CHAR), "LOADED_DELIVERY_FLAG" VARCHAR2 (3 CHAR), "LOADED_ORDERS_FLAG" VARCHAR2 (3 CHAR), "LOADED_SUBS_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLR_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLU_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLXREF_FLAG" VARCHAR2 (3 CHAR), "LOADED_WLY_FLAG" VARCHAR2 (3 CHAR), "LOADED_PRICING_FLAG" VARCHAR2 (3 CHAR), "INFA_COMPLETE_FLAG" VARCHAR2 (3 CHAR), "UPDATE_TIMESTAMP" DATE, "CALENDAR_WEEK_END" VARCHAR2 (10 CHAR), "SHORT_REP_DATE" VARCHAR2 (22 CHAR), CONSTRAINT "TIMEDIM_MONTH_PK" PRIMARY KEY ("TIME_DIM_KEY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" PARALLEL 8 /* Formatted on 6/21/2012 11:38:53 AM (QP5 v5.215.12089.38647) */ CREATE TABLE "TRDW"."USAGEOPTIONSDIM" ( "ZACCMETHD_TXT" VARCHAR2 (120 CHAR), "USAGEOPTIONDIM_KEY" NUMBER (10, 0) NOT NULL ENABLE, "ZBILLOPT_TXT" VARCHAR2 (20 CHAR), "ZFINDTYPE_TXT" VARCHAR2 (40 CHAR), "ZFMTCODE_TXT" VARCHAR2 (60 CHAR), "ZINCLEXCL_TXT" VARCHAR2 (20 CHAR), "ZMETER" VARCHAR2 (3 CHAR), "ZMETER_TXT" VARCHAR2 (40 CHAR), "ZPBILLOPT" VARCHAR2 (3 CHAR), "ZPBILLOPT_TXT" VARCHAR2 (20 CHAR), "ZPRTDEST_TXT" VARCHAR2 (60 CHAR), "ZPRTTYPE_TXT" VARCHAR2 (20 CHAR), "ZBILLOPT" VARCHAR2 (3 CHAR), "ZINTLACCT" VARCHAR2 (3 CHAR), "ZSRCHTYPE_TXT" VARCHAR2 (40 CHAR), "ZUDMIND" VARCHAR2 (3 CHAR), "ZCLIPFQ" VARCHAR2 (3 CHAR), "ZCLIPFQ_TXT" VARCHAR2 (60 CHAR), "UPDATE_TIMESTAMP" DATE, "ZACCMETHD" VARCHAR2 (3 CHAR), "ZINCLEXCL" VARCHAR2 (3 CHAR), "ZSRCHTYPE" VARCHAR2 (3 CHAR), "ZFMTCODE" VARCHAR2 (3 CHAR), "ZFINDTYPE" VARCHAR2 (2 CHAR), "ZPRTDEST" VARCHAR2 (3 CHAR), "ZPRTTYPE" VARCHAR2 (3 CHAR), "ZWAIVER" VARCHAR2 (3 CHAR), "ZTRAIL_CODE" VARCHAR2 (3 CHAR), "ZTRAIL_CODE_TXT" VARCHAR2 (90 CHAR), "ZIMAGE_CODE" VARCHAR2 (3 CHAR), "ZIMAGE_CODE_TXT" VARCHAR2 (15 CHAR), CONSTRAINT "USAGEOPTIONSDIM_PK" PRIMARY KEY ("USAGEOPTIONDIM_KEY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" PARALLEL 16 /* Formatted on 6/21/2012 11:39:18 AM (QP5 v5.215.12089.38647) */ CREATE TABLE "TRDW"."CUSTOMER" ( "CUSTOMER_NUMBER" VARCHAR2 (10 CHAR) NOT NULL ENABLE, "CUSTOMER_KEY" NUMBER (38, 0) NOT NULL ENABLE, "CUST_PROSPECT_FLAG" VARCHAR2 (3 CHAR) NOT NULL ENABLE, "ADDR_NUMBR" VARCHAR2 (10 CHAR), "CITY" VARCHAR2 (105 CHAR), "COUNTRY" VARCHAR2 (9 CHAR), "CUST_CLASS" VARCHAR2 (2 CHAR), "INDUSTRY" VARCHAR2 (4 CHAR), "INDUSTRY_TXT" VARCHAR2 (60 CHAR), "IND_CODE_1" VARCHAR2 (10 CHAR), "IND_CODE_2" VARCHAR2 (10 CHAR), "IND_CODE_3" VARCHAR2 (10 CHAR), "IND_CODE_4" VARCHAR2 (10 CHAR), "IND_CODE_5" VARCHAR2 (10 CHAR), "IND_CODE_1_TXT" VARCHAR2 (20 CHAR), "IND_CODE_2_TXT" VARCHAR2 (20 CHAR), "IND_CODE_3_TXT" VARCHAR2 (20 CHAR), "IND_CODE_4_TXT" VARCHAR2 (20 CHAR), "IND_CODE_5_TXT" VARCHAR2 (20 CHAR), "NAME" VARCHAR2 (105 CHAR), "NIELSEN_ID" VARCHAR2 (2 CHAR), "PHONE" VARCHAR2 (48 CHAR), "POSTAL_CD" VARCHAR2 (30 CHAR), "POSTCD_GIS" VARCHAR2 (10 CHAR), "REGION" VARCHAR2 (9 CHAR), "STREET" VARCHAR2 (105 CHAR), "ZTITLE" VARCHAR2 (45 CHAR), "ZNAME2" VARCHAR2 (105 CHAR), "ZNAME3" VARCHAR2 (105 CHAR), "POBOX" VARCHAR2 (30 CHAR), "CITY_1" VARCHAR2 (40 CHAR), "FAX_NUMBER" VARCHAR2 (30 CHAR), "ZPHONE2" VARCHAR2 (48 CHAR), "ZEMAIL" VARCHAR2 (180 CHAR), "ZURL" VARCHAR2 (150 CHAR), "ZNOTES" VARCHAR2 (50 CHAR), "ACCNT_GRP" VARCHAR2 (4 CHAR), "ZFIRMRANK" VARCHAR2 (5 CHAR), "ZLEG_STAT" VARCHAR2 (2 CHAR), "ZORDR_BLK" VARCHAR2 (2 CHAR), "ZCUSATTR1" VARCHAR2 (2 CHAR), "ZCUSATTR2" VARCHAR2 (2 CHAR), "ZCUSATTR3" VARCHAR2 (2 CHAR), "ZCUSATTR4" VARCHAR2 (2 CHAR), "ZCUSATTR5" VARCHAR2 (2 CHAR), "ZCUSATTR6" VARCHAR2 (3 CHAR), "ZCUSATTR7" VARCHAR2 (3 CHAR), "ZCUSATTR8" VARCHAR2 (3 CHAR), "ZCUSATTR9" VARCHAR2 (3 CHAR), "ZCUSATTR0" VARCHAR2 (3 CHAR), "CUSATTR1_TXT" VARCHAR2 (20 CHAR), "CUSATTR2_TXT" VARCHAR2 (20 CHAR), "CUSATTR3_TXT" VARCHAR2 (20 CHAR), "CUSATTR4_TXT" VARCHAR2 (20 CHAR), "CUSATTR5_TXT" VARCHAR2 (20 CHAR), "CUSATTR6_TXT" VARCHAR2 (20 CHAR), "CUSATTR7_TXT" VARCHAR2 (20 CHAR), "CUSATTR8_TXT" VARCHAR2 (20 CHAR), "CUSATTR9_TXT" VARCHAR2 (20 CHAR), "CUSATTR0_TXT" VARCHAR2 (20 CHAR), "CREATEDON" VARCHAR2 (8 CHAR), "ZDEL_FLAG" VARCHAR2 (3 CHAR), "ZCARR_RTE" VARCHAR2 (15 CHAR), "ZJURISDIC" VARCHAR2 (15 CHAR), "ZORDERCDE" VARCHAR2 (6 CHAR), "TRZONE" VARCHAR2 (10 CHAR), "TR_ZONE_TXT" VARCHAR2 (20 CHAR), "POSTCD_BOX" VARCHAR2 (10 CHAR), "ZNUM_EMPL" VARCHAR2 (6 CHAR), "ZNUMEMPYR" VARCHAR2 (4 CHAR), "ZBRNCHNAM" VARCHAR2 (8 CHAR), "ZDEV_PNT" VARCHAR2 (25 CHAR), "DIVISION" VARCHAR2 (2 CHAR), "DISTR_CHAN" VARCHAR2 (2 CHAR), "SALESORG" VARCHAR2 (4 CHAR), "CUST_GROUP" VARCHAR2 (2 CHAR), "ACCNT_ASGN" VARCHAR2 (2 CHAR), "ZCRED_TRM" VARCHAR2 (4 CHAR), "ZLIST_SCH" VARCHAR2 (2 CHAR), "COMP_CODE" VARCHAR2 (4 CHAR), "CUST_COMPC" VARCHAR2 (10 CHAR), "ZPREV_NUM" VARCHAR2 (10 CHAR), "CHRT_ACCTS" VARCHAR2 (4 CHAR), "RC_ACCOUNT" VARCHAR2 (10 CHAR), "UPDATE_TIMESTAMP" DATE, "REGION_TXT" VARCHAR2 (60 CHAR), "ACCNT_GRP_TXT" VARCHAR2 (40 CHAR), "LEG_STAT_TXT" VARCHAR2 (20 CHAR), "ORDR_BLK_TXT" VARCHAR2 (20 CHAR), "DEL_FLAG_TXT" VARCHAR2 (20 CHAR), "DIVISION_TXT" VARCHAR2 (20 CHAR), "DISTR_CHAN_TXT" VARCHAR2 (20 CHAR), "SALESORG_TXT" VARCHAR2 (60 CHAR), "CUST_GROUP_TXT" VARCHAR2 (20 CHAR), "ACCNT_ASSGN_TXT" VARCHAR2 (20 CHAR), "CRED_TRM_TXT" VARCHAR2 (20 CHAR), "LIST_SCH_TXT" VARCHAR2 (20 CHAR), "COMP_CODE_TXT" VARCHAR2 (60 CHAR), "CHRT_ACCTS_TXT" VARCHAR2 (60 CHAR), "MDB_CUST_NUM" NUMBER (19, 0), "COUNTRY_TXT" VARCHAR2 (40), "CUST_CLASS_TXT" VARCHAR2 (20 CHAR), "CUSTOMER_TXT" VARCHAR2 (120 CHAR), "ZMDBCUST" VARCHAR2 (19 CHAR), "ZXMKTSEG" VARCHAR2 (30 CHAR), "NUM_ATT_LOC" NUMBER (38, 0), "NUM_ATT_ORG" NUMBER (38, 0), "NUM_NATT_LOC" NUMBER (38, 0), "NUM_NATT_ORG" NUMBER (38, 0), "NUM_EMP_MDB" NUMBER (38, 0), "CUST_CLA" VARCHAR2 (2 CHAR), "CUSTOMER_GRP1" VARCHAR2 (9 CHAR), "CUSTOMER_GRP2" VARCHAR2 (3 CHAR), "CUSTOMER_GRP3" VARCHAR2 (3 CHAR), "CUSTOMER_GRP4" VARCHAR2 (3 CHAR), "CUSTOMER_GRP5" VARCHAR2 (3 CHAR), "ZXMKTSEG2" VARCHAR2 (30 CHAR), "ZSALESDIV2" VARCHAR2 (19 CHAR), "RPM_AUTH_GRP" VARCHAR2 (4 CHAR), "RPM_ORD_CD" VARCHAR2 (6 CHAR), "SOLO_FLAG" VARCHAR2 (3 CHAR), "NP_AO" VARCHAR2 (3 CHAR), "NP_ACADEMIC" VARCHAR2 (3 CHAR), "NP_ANLYS_SEG" VARCHAR2 (20 CHAR), "NP_BASIC_EXCLUDE" VARCHAR2 (3 CHAR), "NP_BASE_LIST_NOFED" VARCHAR2 (3 CHAR), "NP_JUDGE" VARCHAR2 (3 CHAR), "NP_USA_DEFINE" VARCHAR2 (20 CHAR), "NP_MKG_DIVISION" VARCHAR2 (20 CHAR), "CREATEDBY" VARCHAR2 (18 CHAR), "SEARCHTERM1" VARCHAR2 (20 CHAR), "MKTSEG_TEMP_2003" VARCHAR2 (30 CHAR), "MDB_CUST_NUM_CHAR" VARCHAR2 (30 CHAR), "FR_MKTSEG" VARCHAR2 (30 CHAR), "FR_MKTSEG_ALT" VARCHAR2 (30 CHAR), "FR_FLAG" VARCHAR2 (3 CHAR), "CURRENCY_TYPE" VARCHAR2 (5 CHAR), "SORT2_SEARCH_TERM2" VARCHAR2 (20 CHAR), "ADDRSTATUS_FL" VARCHAR2 (60 CHAR), "ACCT_ROLL_KEY" NUMBER (38, 0), "ACCT_ROLL_ID" NUMBER (19, 0), "FR_FLAG_ALT" VARCHAR2 (30 CHAR), "SECURITY_ID" NUMBER (38, 0), "MARKET_RESEARCH_FLAG" VARCHAR2 (3 CHAR), "MARKET_RESEARCH_TXT" VARCHAR2 (25 CHAR), "RUTTER_SOLICITATION_FLAG" VARCHAR2 (3 CHAR), "RUTTER_SOLICITATION_TXT" VARCHAR2 (30 CHAR), "DUNS_NUMBER" VARCHAR2 (9 CHAR), "TAMS_FL" VARCHAR2 (3 CHAR), "TAMS_MKTSEG" VARCHAR2 (30 CHAR), "ORIGINATION_SOURCE" VARCHAR2 (30 CHAR), "BRANCH_ROLL_ID" NUMBER (19, 0), "BRANCH_ROLL_ID_NUM" NUMBER (19, 0), "WEG_SCHOOL_ID" NUMBER (38, 0), "ACCT_ROLL_ID_REASON" VARCHAR2 (50 CHAR), "ORG_TYPE" VARCHAR2 (15 CHAR), "ORG_TYPE_MAIN" VARCHAR2 (10 CHAR), "ADV_PRICING_FLAG" VARCHAR2 (3 CHAR), "SMG_SAP_ACCOUNT_NUM" VARCHAR2 (10 CHAR), "SMG_SAP_MDB_ACCOUNT_NUM" VARCHAR2 (50 CHAR), "SIEBEL_ROW_ID" VARCHAR2 (30 CHAR), "SFDC_ID" VARCHAR2 (18 CHAR), CONSTRAINT "CUSTOMER_PK" PRIMARY KEY ("CUSTOMER_KEY") DISABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TRDW_D000" PARALLEL 16