Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_functionaldependency.sql
CREATE OR REPLACE PROCEDURE wb_rt_updateProperties wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 7 9200000 1 4 0 2d 2 :e: 1WB_RT_UPDATEPROPERTIES: 1LVL: 1NUMBER: 1TBLID: 1AUTHID: 1CURRENT_USER: 1ROWIDTABLE: 1WB_RT_PROFILE_SERVICE: 1ROWIDTYPE: 1NUMNULLSTABLE: 1NUMBERTYPE: 1STMT: 1VARCHAR2: 12000: 1NULLVAL: 110: 11: 1I: 1BINARY_INTEGER: 10: 1=: 12: 1C: 1ROWID: 1ROWIDVAL: 1PARTITION_DTYPENAME: 1PARTITION_NAME: 1OWBSYS: 1WB_RTV_DP_PARTITION_METADATA: 1TABLE_ID: 1PARTITION_LEVEL: 1LOOP: 1select rowid rowidval,partition_dtypename,partition_name from :n owbsys.+ 1wb_rtv_dp_partition_metadata where table_id = tblID and partition_level = lvl: 1select count(1) from : 1||: 1 where : 1 = : 1EXECUTE: 1IMMEDIATE: 1+: 1FORALL: 1INDX: 1LAST: 1NUM_NULLS: 1UPDATE owbsys.wb_rtv_dp_partition_metadata set num_nulls = numNullsTable(indx+ 1):n where rowid = rowidTable(indx): 0 0 0 9f 2 0 9a 8f a0 b0 3d 8f a0 b0 3d b4 :2 a0 55 6a a3 :2 a0 6b 1c 81 b0 a3 :2 a0 6b 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 6e 81 b0 a3 a0 1c 51 81 b0 a0 7e 51 b4 2e 5a a0 6e d b7 19 3c 91 :b a0 12a 37 :2 a0 a5 b :2 a0 6b d a0 6e 7e :2 a0 6b b4 2e 7e 6e b4 2e 7e :2 a0 6b b4 2e 7e 6e b4 2e 7e a0 b4 2e d :5 a0 a5 b 11e 11d :2 a0 7e 51 b4 2e d b7 a0 47 a0 118 51 :2 a0 6b 63 :8 a0 12a 111 b7 47 b7 a4 a0 b1 11 68 4f 1d 17 b5 9f 2 0 3 1f 1b 1a 27 34 30 17 3c 2f 41 45 49 4d 6a 55 59 2c 5d 65 54 8a 75 79 51 7d 85 74 a7 95 71 99 9a a2 94 c9 b2 91 b6 b7 bf c4 b1 e5 d4 d8 ae e0 d3 ec d0 f0 f3 f4 f9 fc 100 105 109 10b 10f 112 116 11a 11e 122 126 12a 12e 132 136 13a 13e 142 14e 150 154 158 159 15b 15f 163 166 16a 16e 173 176 17a 17e 181 182 187 18a 18f 190 195 198 19c 1a0 1a3 1a4 1a9 1ac 1b1 1b2 1b7 1ba 1be 1bf 1c4 1c8 1cc 1d0 1d4 1d8 1dc 1dd 1df 1e4 1e8 1ec 1f0 1f3 1f6 1f7 1fc 200 202 206 20d 211 215 218 21c 220 223 227 22b 22f 233 237 23b 23f 243 247 253 256 258 25f 261 265 269 26b 277 27b 27d 27e 287 9f 2 0 b 22 29 :2 22 3 c :2 3 21 14 1b :2 1 3 e 24 :3 e :2 3 11 27 :3 11 :2 3 8 11 10 :2 8 :2 3 b 14 13 b 1a b :2 3 :2 5 16 5 3 9 d f :2 d 8 7 11 7 12 :2 5 9 16 1c 25 39 7 e 31 3c 46 58 5d e 5 7 12 :2 7 17 :2 19 :2 7 e 26 29 :2 2b :2 e 3a 3d :2 e 47 9 :2 b :2 e 1f 22 :2 e 28 2b :2 e :2 7 f 19 23 31 :2 23 :3 7 b c d :2 b 7 5d 9 :2 5 c 14 17 :2 25 11 e 15 36 42 50 f 17 22 7 :2 5 11 :2 3 7 :7 1 9f 4 0 :5 1 :4 2 1 :2 2 :2 1 :7 3 :7 4 :7 5 :8 6 :6 7 :6 9 :3 a :3 9 :5 c :7 d :2 c :8 e :d f :3 10 :2 f :2 10 :2 f :2 10 :3 f :9 11 :7 12 d 13 c :7 14 :5 15 :3 16 15 :3 14 :2 8 17 :7 1 289 4 :3 0 1 :a 0 9a 1 :7 0 5 2c 0 :2 3 :3 0 2 :7 0 4 3 :3 0 10 11 0 7 3 :3 0 4 :7 0 8 7 :3 0 5 :3 0 6 :3 0 a :2 0 9a 1 d :2 0 17 18 0 a 8 :3 0 9 :2 0 4 12 :7 0 15 13 0 98 0 7 :6 0 e :2 0 c 8 :3 0 b :2 0 4 19 :7 0 1c 1a 0 98 0 a :6 0 10 :2 0 10 d :3 0 e 1e 20 :6 0 23 21 0 98 0 c :6 0 14 :2 0 14 d :3 0 12 25 27 :6 0 11 :4 0 2b 28 29 98 0 f :6 0 15 :2 0 16 13 :3 0 2d :7 0 31 2e 2f 98 0 12 :6 0 2 :3 0 11 :2 0 1a 33 35 :3 0 36 :2 0 f :3 0 16 :4 0 38 39 0 3b 1d 3c 37 3b 0 3d 1f 0 95 17 :3 0 18 :3 0 19 :3 0 1a :3 0 1b :3 0 1c :3 0 1d :3 0 1e :3 0 4 :3 0 1f :3 0 2 :3 0 20 :4 0 21 1 :8 0 4b 3e 4a 7 :3 0 12 :3 0 21 4c 4e 17 :3 0 19 :3 0 50 51 0 4f 52 0 7f c :3 0 22 :4 0 23 :2 0 17 :3 0 1b :3 0 57 58 0 23 56 5a :3 0 23 :2 0 24 :4 0 26 5c 5e :3 0 23 :2 0 17 :3 0 1a :3 0 61 62 0 29 60 64 :3 0 23 :2 0 25 :4 0 2c 66 68 :3 0 23 :2 0 f :3 0 2f 6a 6c :3 0 54 6d 0 7f 26 :3 0 27 :3 0 c :3 0 a :3 0 12 :3 0 32 72 74 71 75 :3 0 76 :2 0 7f 12 :3 0 12 :3 0 28 :2 0 11 :2 0 34 7a 7c :3 0 78 7d 0 7f 37 81 20 :3 0 4b 7f :4 0 95 29 :3 0 2a :3 0 14 :2 0 a :3 0 2b :3 0 85 86 0 84 87 :2 0 1c :3 0 1d :3 0 2c :3 0 a :3 0 2a :3 0 18 :3 0 7 :3 0 2a :4 0 2d 1 :8 0 93 83 88 0 3c 94 92 93 :4 0 95 3e 99 :3 0 99 1 :3 0 42 99 98 95 96 :6 0 9a :2 0 1 d 99 9d :3 0 9c 9a 9e :4 0 6 :3 0 48 4 :3 0 1 2 1 6 2 5 9 1 f 1 16 1 1f 1 1d 1 26 1 24 1 2c 1 34 2 32 34 1 3a 1 3c 1 4d 2 55 59 2 5b 5d 2 5f 63 2 65 67 2 69 6b 1 73 2 79 7b 4 53 6e 77 7e 1 91 3 3d 81 94 5 14 1b 22 2a 30 1 4 0 9d 0 1 14 3 a 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16 1 0 83 3 0 1d 1 0 f 1 0 1 0 1 2 1 0 3e 2 0 2c 1 0 24 1 0 6 1 0 0 / CREATE OR REPLACE PROCEDURE wb_rt_getPartitionProperties wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 7 9200000 1 4 0 22 2 :e: 1WB_RT_GETPARTITIONPROPERTIES: 1NAME: 1VARCHAR2: 1NUMSETS: 1OUT: 1NUMBER: 1NUMELEMS: 1MAXSETCOUNT: 1NUMNULLS: 1TESTQUERY: 1AUTHID: 1CURRENT_USER: 1NUMSETSELEMSSTMT: 14000: 1select count(distinct(value)),count(1) from : 1||: 1MAXSTMT: 1select max(count(1)) from : 1 group by value: 1NUMNULLSSTMT: 1select count(1) from : 1 where isnull = 1: 1STMT: 1: 1IS NOT NULL: 1select count(1) from (select distinct : 1 from : 1): 1EXECUTE: 1IMMEDIATE: 1 where : 1 is null: 1IS NULL: 10: 0 0 0 c8 2 0 9a 8f a0 b0 3d 96 :2 a0 b0 54 96 :2 a0 b0 54 96 :2 a0 b0 54 96 :2 a0 b0 54 8f a0 4d b0 3d b4 :2 a0 55 6a a3 a0 51 a5 1c 6e 7e a0 b4 2e 81 b0 a3 a0 51 a5 1c 6e 7e a0 b4 2e 7e 6e b4 2e 81 b0 a3 a0 51 a5 1c 6e 7e a0 b4 2e 7e 6e b4 2e 81 b0 a3 a0 51 a5 1c 6e 81 b0 a0 7e b4 2e 5a a0 6e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e d :4 a0 11e 11d a0 6e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e d :4 a0 11e 11d b7 :5 a0 11e 5 11d :4 a0 11e 11d :4 a0 11e 11d a0 7e b4 2e 5a a0 51 d b7 19 3c a0 7e b4 2e 5a a0 51 d b7 19 3c b7 :2 19 3c b7 a4 a0 b1 11 68 4f 1d 17 b5 c8 2 0 3 1f 1b 1a 27 38 30 34 17 3f 4c 44 48 2f 53 64 5c 60 2c 6b 78 70 74 5b 7f 8c 88 58 87 94 84 99 9d a1 a5 d4 ad b1 b4 b5 bd c2 c5 c9 ca cf ac 111 df a9 e3 e4 ec f1 f4 f8 f9 fe 101 106 107 10c de 14e 11c db 120 121 129 12e 131 135 136 13b 13e 143 144 149 11b 170 159 118 15d 15e 166 16b 158 177 155 17b 17c 181 184 188 18d 190 194 195 19a 19d 1a2 1a3 1a8 1ab 1af 1b0 1b5 1b8 1bd 1be 1c3 1c7 1cb 1cf 1d3 1d7 1dc 1e0 1e4 1e9 1ec 1f0 1f1 1f6 1f9 1fe 1ff 204 207 20b 20c 211 214 219 21a 21f 223 227 22b 22f 233 238 23c 23e 242 246 24a 24e 252 257 25b 25f 263 267 26b 26f 274 278 27c 280 284 288 28d 291 295 298 299 29e 2a1 2a5 2a8 2ac 2ae 2b2 2b5 2b9 2bc 2bd 2c2 2c5 2c9 2cc 2d0 2d2 2d6 2d9 2db 2df 2e3 2e6 2e8 2ec 2f0 2f2 2fe 302 304 305 30e c8 2 0 b 28 30 :2 28 39 41 45 :2 39 3 c 10 :2 3 17 23 27 :2 17 2e 37 3b :2 2e 3 10 21 :2 3 27 3 a :2 1 3 14 1d 1c 14 5 34 37 :2 5 14 :2 3 b 14 13 b 1c 39 3c :2 1c 41 5 :2 1c b :2 3 10 19 18 10 21 39 3c :2 21 41 5 :2 21 10 :2 3 8 11 10 8 19 8 3 :4 9 8 7 e 37 3a :2 e 44 9 :2 e 12 15 :2 e 1a 1d :2 e :2 7 f 19 23 :3 7 e 26 29 :2 e 2e 31 :2 e 3b 9 :2 e 13 16 :2 e :2 7 f 19 23 :2 7 20 7 f 19 2f 37 :4 7 f 19 26 :3 7 f 19 2b :2 7 :4 b a 9 14 9 1d :2 7 :4 b a 9 17 9 20 :2 7 :4 5 :2 3 7 :7 1 c8 4 0 :a 1 :f 2 :5 3 1 :2 4 :2 1 :5 5 :5 6 :2 5 :b 7 8 :4 7 :b 9 a :4 9 :8 b :5 d :7 e f :2 e :2 f :2 e :2 f :3 e :6 10 :b 11 12 :2 11 :2 12 :3 11 :6 13 d :8 15 :6 16 :6 17 :5 18 :3 19 :3 18 :5 1b :3 1c :3 1b 14 :3 d :2 c 1f :7 1 310 4 :3 0 1 :a 0 c3 1 :7 0 5 2c 0 :2 3 :3 0 2 :7 0 4 3 :3 0 9 58 0 7 5 :3 0 6 :3 0 4 :6 0 9 8 :3 0 5 :3 0 6 :3 0 7 :6 0 e d :6 0 b 5 :3 0 6 :3 0 8 :6 0 13 12 :3 0 5 :3 0 6 :3 0 9 :6 0 18 17 :3 0 f :2 0 d 3 :3 0 a :7 0 1d 1b 1c :2 0 b :3 0 c :3 0 1f :2 0 c3 1 22 :2 0 e :2 0 1b 3 :3 0 e :2 0 16 25 27 :6 0 f :4 0 10 :2 0 2 :3 0 18 2a 2c :3 0 2f 28 2d c1 0 d :6 0 e :2 0 25 3 :3 0 1d 31 33 :6 0 12 :4 0 10 :2 0 2 :3 0 1f 36 38 :3 0 10 :2 0 13 :4 0 22 3a 3c :3 0 3f 34 3d c1 0 11 :6 0 e :2 0 2f 3 :3 0 27 41 43 :6 0 15 :4 0 10 :2 0 2 :3 0 29 46 48 :3 0 10 :2 0 16 :4 0 2c 4a 4c :3 0 4f 44 4d c1 0 14 :6 0 19 :2 0 33 3 :3 0 31 51 53 :6 0 18 :4 0 57 54 55 c1 0 17 :6 0 a :3 0 35 59 5a :3 0 5b :2 0 17 :3 0 1a :4 0 10 :2 0 a :3 0 37 5f 61 :3 0 10 :2 0 1b :4 0 3a 63 65 :3 0 10 :2 0 2 :3 0 3d 67 69 :3 0 10 :2 0 1c :4 0 40 6b 6d :3 0 5d 6e 0 8f 1d :3 0 1e :3 0 17 :3 0 7 :3 0 72 73 :3 0 74 :2 0 8f 17 :3 0 15 :4 0 10 :2 0 2 :3 0 43 78 7a :3 0 10 :2 0 1f :4 0 46 7c 7e :3 0 10 :2 0 a :3 0 49 80 82 :3 0 10 :2 0 20 :4 0 4c 84 86 :3 0 76 87 0 8f 1d :3 0 1e :3 0 17 :3 0 9 :3 0 8b 8c :3 0 8d :2 0 8f 4f bb 1d :3 0 1e :3 0 d :3 0 4 :3 0 7 :3 0 92 96 :3 0 54 :3 0 95 :2 0 ba 1d :3 0 1e :3 0 11 :3 0 8 :3 0 9a 9b :3 0 9c :2 0 ba 1d :3 0 1e :3 0 14 :3 0 9 :3 0 a0 a1 :3 0 a2 :2 0 ba 7 :3 0 21 :2 0 57 a5 a6 :3 0 a7 :2 0 7 :3 0 22 :2 0 a9 aa 0 ac 59 ad a8 ac 0 ae 5b 0 ba 8 :3 0 21 :2 0 5d b0 b1 :3 0 b2 :2 0 8 :3 0 22 :2 0 b4 b5 0 b7 5f b8 b3 b7 0 b9 61 0 ba 63 bc 5c 8f 0 bd 0 ba 0 bd 69 0 be 6c c2 :3 0 c2 1 :3 0 6e c2 c1 be bf :6 0 c3 :2 0 1 22 c2 c6 :3 0 c5 c3 c7 :4 0 c :3 0 73 4 :3 0 1 2 1 6 1 b 1 10 1 15 1 1a 6 5 a f 14 19 1e 1 26 2 29 2b 1 24 1 32 2 35 37 2 39 3b 1 30 1 42 2 45 47 2 49 4b 1 40 1 52 1 50 1 58 2 5e 60 2 62 64 2 66 68 2 6a 6c 2 77 79 2 7b 7d 2 7f 81 2 83 85 4 6f 75 88 8e 2 93 94 1 a4 1 ab 1 ad 1 af 1 b6 1 b8 5 97 9d a3 ae b9 2 bb bc 1 bd 4 2e 3e 4e 56 1 4 0 c6 0 1 14 1 b 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 0 b 1 0 40 1 0 6 1 0 50 1 0 1a 1 0 30 1 0 15 1 0 24 1 0 10 1 0 1 0 1 0 / /** * This tests A->B, where v1 is A, lg is A,B_cnt, rg is A_cnt * partition1 is A, partition2 is A,B * @param partition1 X \ {A} column * @param partition2 X column * @return number of errors such that the functional dependency X->A will hold */ CREATE OR REPLACE FUNCTION wb_rt_getErrorWithName wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 8 9200000 1 4 0 4c 2 :e: 1FUNCTION: 1WB_RT_GETERRORWITHNAME: 1THRESHOLD: 1NUMBER: 1PARTITION1: 1VARCHAR2: 1PARTITION1COL: 1PARTITION1CNT: 1PARTITION1ID: 1PARTITION1LEVEL: 1PARTITION1DTYPE: 1PARTITION2: 1PARTITION2COL: 1PARTITION2CNT: 1PARTITION2ID: 1TBLID: 1PRFID: 1RETURN: 1AUTHID: 1CURRENT_USER: 1STMT: 14000: 1: 1ROWIDVAL: 110: 1rowidval: 1NUMERRORS: 1select sum(max(rg) - max(lg)) from (: 1||: 1 select a.: 1 v1, b.: 1 lg ,a.: 1 rg from : 1 a,: 1 b where a.: 1 <> 2 and a.: 1 = b.rowidval) group by v1: 1EXECUTE: 1IMMEDIATE: 1<=: 1insert /*+append parallel(wb_rt_dp_partition_error) */ : 1into wb_rt_dp_partition_error: 1(invocation_id,table_id,rowidval,x_u_a_id,x_id) : 1with lc as (: 1select aa.rowidval,aa.: 1 a,aa.: 1 a_cnt,bb.: 1 c,bb.: 1 c_cnt from : 1 aa,: 1 bb where aa.rowidval = : 1bb.rowidval and aa.: 1 <> 2 and : 1aa.: 1 <> bb.: 1): 1select ::prfID,::tblID,rowidval,::partitionID2,::partitionID1 from (: 1select rowidval,a_cnt-c_cnt cnt,row_number() over : 1(partition by a order by c_cnt) top from (: 1select a,a_cnt,c_cnt,rowidval from lc x : 1where exists (select 1 from (select a,max(c_cnt) max from lc group by a) y : 1where x.a = y.a and x.c_cnt < y.max))) where top <= cnt : 1union all : 1select rowidval,a_cnt-c_cnt cnt,: 1row_number() over (partition by a order by c_cnt) top from (: 1select a,c,count(1) over (partition by a) a_cnt,c_cnt,rowidval : 1from lc x where exists (: 1select 1 from (: 1select c from (: 1select a,c,grpcnt,grpcnt - count(1) cnt from (: 1select a,c,c_cnt,count(c_cnt) over (partition by a) grpcnt,: 1max(c_cnt) over (partition by a) maxcnt from lc order by a,c) : 1where maxcnt = c_cnt group by a,c,grpcnt) : 1where cnt = 0 or grpcnt > 1) y where x.c = y.c))) where top <= cnt: 1USING: 1COMMIT: 0 0 0 176 2 0 a0 8d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d b4 :4 a0 2c 6a a3 a0 51 a5 1c 6e 81 b0 a3 a0 51 a5 1c 6e 81 b0 a3 a0 1c 81 b0 a0 6e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e d :4 a0 11e 11d :2 a0 7e b4 2e 5a a0 6e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e a0 b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e 7e 6e b4 2e d :5 a0 112 a0 112 a0 112 a0 112 a0 112 a0 112 a0 112 a0 112 11e 11a 11d a0 12a b7 19 3c :2 a0 65 b7 a4 a0 b1 11 68 4f 1d 17 b5 176 2 0 3 7 23 1f 1e 2b 38 34 1b 40 49 45 33 51 5e 5a 30 66 6f 6b 59 77 84 80 56 8c 95 91 7f 9d aa a6 7c b2 bb b7 a5 c3 d0 cc a2 d8 e1 dd cb e9 f6 f2 c8 fe 107 103 f1 10f ee 114 118 11c 120 124 128 14a 130 134 137 138 140 145 12f 16c 155 12c 159 15a 162 167 154 188 177 17b 183 151 173 18f 194 197 19c 19d 1a2 1a5 1a9 1aa 1af 1b2 1b7 1b8 1bd 1c0 1c4 1c5 1ca 1cd 1d2 1d3 1d8 1db 1df 1e0 1e5 1e8 1ed 1ee 1f3 1f6 1fa 1fb 200 203 208 209 20e 211 215 216 21b 21e 223 224 229 22c 230 231 236 239 23e 23f 244 247 24b 24c 251 254 259 25a 25f 263 267 26b 26f 273 278 27c 280 284 287 288 28d 290 294 299 29c 2a1 2a2 2a7 2aa 2af 2b0 2b5 2b8 2bd 2be 2c3 2c6 2cb 2cc 2d1 2d4 2d8 2d9 2de 2e1 2e6 2e7 2ec 2ef 2f3 2f4 2f9 2fc 301 302 307 30a 30e 30f 314 317 31c 31d 322 325 329 32a 32f 332 337 338 33d 340 344 345 34a 34d 352 353 358 35b 35f 360 365 368 36d 36e 373 376 37b 37c 381 384 388 389 38e 391 396 397 39c 39f 3a4 3a5 3aa 3ad 3b1 3b2 3b7 3ba 3bf 3c0 3c5 3c8 3cc 3cd 3d2 3d5 3da 3db 3e0 3e3 3e8 3e9 3ee 3f1 3f6 3f7 3fc 3ff 404 405 40a 40d 412 413 418 41b 420 421 426 429 42e 42f 434 437 43c 43d 442 445 44a 44b 450 453 458 459 45e 461 466 467 46c 46f 474 475 47a 47d 482 483 488 48b 490 491 496 499 49e 49f 4a4 4a7 4ac 4ad 4b2 4b5 4ba 4bb 4c0 4c3 4c8 4c9 4ce 4d1 4d6 4d7 4dc 4df 4e4 4e5 4ea 4ee 4f2 4f6 4fa 4fe 502 503 507 508 50c 50d 511 512 516 517 51b 51c 520 521 525 526 52b 52c 530 534 540 542 546 549 54d 551 555 557 55b 55f 561 56d 571 573 574 57d 176 2 0 1 a 21 2e :2 21 3 11 :2 3 1a 2b :2 1a 34 45 :2 34 3 13 :2 3 1a 2d :2 1a 34 47 :2 34 3 11 :2 3 1a 2b :2 1a 34 45 :2 34 3 13 :2 3 1a 23 :2 1a 2a 33 :2 2a 20 3b 42 3 a :2 1 3 8 11 10 8 18 8 :2 3 c 15 14 c 1b c :2 3 :3 d 3 5 c 33 7 :2 c 14 17 :2 c 25 28 :2 c 32 35 :2 c 43 7 :2 c 11 14 :2 c 22 25 :2 c 31 34 :2 c 3f 42 :2 c 48 7 :2 c 12 15 :2 c 23 26 :2 c 36 39 :2 c 48 7 :2 c 10 13 :2 c :2 5 d 17 21 :2 5 9 16 :3 13 8 7 e 48 9 :2 e 29 9 :2 e 3c 9 :2 e 18 9 :2 e 22 25 :2 e 33 36 :2 e 3f 9 :2 e 17 1a :2 e 27 2a :2 e 38 3b :2 e 44 9 :2 e 17 1a :2 e 29 9 :2 e 14 17 :2 e 1e 21 :2 e 2c 2f :2 e 4a 9 :2 e 1f 22 :2 e 32 35 :2 e 42 9 :2 e f 12 :2 e 20 23 :2 e 2d 30 :2 e 3e 41 :2 e 45 9 :2 e 4c 9 :2 e 3e 9 :2 e 36 9 :2 e 34 9 :2 e 57 9 :2 e 44 9 :2 e 16 9 :2 e 4c 9 :2 e 2c 9 :2 e 48 9 :2 e 4b 9 :2 e 24 9 :2 e 1b 9 :2 e 1b 9 :2 e 3a 9 :2 e 47 9 :2 e 4a 9 :2 e 36 9 :2 e :2 7 f 19 1e 24 1e 2a 29 30 2f 3d 3c 9 49 f e 15 14 22 21 :5 7 21 :3 5 c 5 :2 3 7 :7 1 176 4 0 :6 1 :c 2 :c 3 :c 4 :c 5 1 :2 5 :2 6 :2 1 :8 7 :8 8 :5 9 :3 b c :2 b :2 c :2 b :2 c :2 b :2 c :2 b c d :2 b :2 d :2 b :2 d :2 b :2 d :2 b :2 d :2 b d e :2 b :2 e :2 b :2 e :2 b :2 e :2 b e f :2 b :2 f :3 b :6 10 :6 11 :3 12 13 :2 12 13 14 :2 12 14 15 :2 12 15 16 :2 12 :2 16 :2 12 :2 16 :2 12 16 17 :2 12 :2 17 :2 12 :2 17 :2 12 :2 17 :2 12 17 18 :2 12 :2 18 :2 12 18 19 :2 12 :2 19 :2 12 :2 19 :2 12 :2 19 :2 12 19 1a :2 12 :2 1a :2 12 :2 1a :2 12 1a 1b :2 12 :2 1b :2 12 :2 1b :2 12 :2 1b :2 12 :2 1b :2 12 1b 1c :2 12 1c 1d :2 12 1d 1e :2 12 1e 1f :2 12 1f 20 :2 12 20 21 :2 12 21 22 :2 12 22 23 :2 12 23 24 :2 12 24 25 :2 12 25 26 :2 12 26 27 :2 12 27 28 :2 12 28 29 :2 12 29 2a :2 12 2a 2b :2 12 2b 2c :2 12 2c 2d :2 12 2d 2e :3 12 :c 2f 30 2f :6 30 :3 2f :2 31 :3 11 :3 33 :2 a 34 :7 1 57f 4 :3 0 1 :3 0 2 :a 0 171 1 :7 0 5 30 0 3 4 :3 0 3 :7 0 5 4 :3 0 9 56 0 7 6 :3 0 5 :7 0 9 8 :3 0 6 :3 0 7 :7 0 d c :3 0 d 7c 0 b 6 :3 0 8 :7 0 11 10 :3 0 4 :3 0 9 :7 0 15 14 :3 0 11 a2 0 f 4 :3 0 a :7 0 19 18 :3 0 6 :3 0 b :7 0 1d 1c :3 0 15 c8 0 13 6 :3 0 c :7 0 21 20 :3 0 6 :3 0 d :7 0 25 24 :3 0 19 ee 0 17 6 :3 0 e :7 0 29 28 :3 0 4 :3 0 f :7 0 2d 2c :3 0 1d :2 0 1b 4 :3 0 10 :7 0 31 30 :3 0 4 :3 0 11 :7 0 35 34 :3 0 12 :3 0 4 :3 0 13 :3 0 14 :3 0 37 39 0 171 2 3c :2 0 19 :2 0 2d 6 :3 0 16 :2 0 2b 3f 41 :6 0 17 :4 0 45 42 43 16f 0 15 :6 0 33 173 0 31 6 :3 0 2f 47 49 :6 0 1a :4 0 4d 4a 4b 16f 0 18 :6 0 15 :3 0 4 :3 0 4f :7 0 52 50 0 16f 0 1b :6 0 1c :4 0 1d :2 0 1e :4 0 35 55 57 :3 0 1d :2 0 7 :3 0 38 59 5b :3 0 1d :2 0 1f :4 0 3b 5d 5f :3 0 1d :2 0 e :3 0 3e 61 63 :3 0 1d :2 0 20 :4 0 41 65 67 :3 0 1d :2 0 8 :3 0 44 69 6b :3 0 1d :2 0 21 :4 0 47 6d 6f :3 0 1d :2 0 5 :3 0 4a 71 73 :3 0 1d :2 0 22 :4 0 4d 75 77 :3 0 1d :2 0 c :3 0 50 79 7b :3 0 1d :2 0 23 :4 0 53 7d 7f :3 0 1d :2 0 b :3 0 56 81 83 :3 0 1d :2 0 24 :4 0 59 85 87 :3 0 1d :2 0 18 :3 0 5c 89 8b :3 0 1d :2 0 25 :4 0 5f 8d 8f :3 0 53 90 0 16c 26 :3 0 27 :3 0 15 :3 0 1b :3 0 94 95 :3 0 96 :2 0 16c 1b :3 0 3 :3 0 28 :2 0 64 9a 9b :3 0 9c :2 0 15 :3 0 29 :4 0 1d :2 0 2a :4 0 67 a0 a2 :3 0 1d :2 0 2b :4 0 6a a4 a6 :3 0 1d :2 0 2c :4 0 6d a8 aa :3 0 1d :2 0 2d :4 0 70 ac ae :3 0 1d :2 0 7 :3 0 73 b0 b2 :3 0 1d :2 0 2e :4 0 76 b4 b6 :3 0 1d :2 0 8 :3 0 79 b8 ba :3 0 1d :2 0 2f :4 0 7c bc be :3 0 1d :2 0 d :3 0 7f c0 c2 :3 0 1d :2 0 30 :4 0 82 c4 c6 :3 0 1d :2 0 e :3 0 85 c8 ca :3 0 1d :2 0 31 :4 0 88 cc ce :3 0 1d :2 0 5 :3 0 8b d0 d2 :3 0 1d :2 0 32 :4 0 8e d4 d6 :3 0 1d :2 0 c :3 0 91 d8 da :3 0 1d :2 0 33 :4 0 94 dc de :3 0 1d :2 0 34 :4 0 97 e0 e2 :3 0 1d :2 0 b :3 0 9a e4 e6 :3 0 1d :2 0 35 :4 0 9d e8 ea :3 0 1d :2 0 36 :4 0 a0 ec ee :3 0 1d :2 0 8 :3 0 a3 f0 f2 :3 0 1d :2 0 37 :4 0 a6 f4 f6 :3 0 1d :2 0 e :3 0 a9 f8 fa :3 0 1d :2 0 38 :4 0 ac fc fe :3 0 1d :2 0 39 :4 0 af 100 102 :3 0 1d :2 0 3a :4 0 b2 104 106 :3 0 1d :2 0 3b :4 0 b5 108 10a :3 0 1d :2 0 3c :4 0 b8 10c 10e :3 0 1d :2 0 3d :4 0 bb 110 112 :3 0 1d :2 0 3e :4 0 be 114 116 :3 0 1d :2 0 3f :4 0 c1 118 11a :3 0 1d :2 0 39 :4 0 c4 11c 11e :3 0 1d :2 0 40 :4 0 c7 120 122 :3 0 1d :2 0 41 :4 0 ca 124 126 :3 0 1d :2 0 42 :4 0 cd 128 12a :3 0 1d :2 0 43 :4 0 d0 12c 12e :3 0 1d :2 0 44 :4 0 d3 130 132 :3 0 1d :2 0 45 :4 0 d6 134 136 :3 0 1d :2 0 46 :4 0 d9 138 13a :3 0 1d :2 0 47 :4 0 dc 13c 13e :3 0 1d :2 0 48 :4 0 df 140 142 :3 0 1d :2 0 49 :4 0 e2 144 146 :3 0 1d :2 0 4a :4 0 e5 148 14a :3 0 9e 14b 0 166 26 :3 0 27 :3 0 15 :3 0 4b :3 0 11 :3 0 151 10 :3 0 153 f :3 0 155 9 :3 0 157 11 :3 0 159 10 :3 0 15b f :3 0 15d 9 :3 0 15f 14f 0 162 :2 0 e8 161 :2 0 166 4c :4 0 4c 1 :8 0 166 f1 167 9d 166 0 168 f5 0 16c 12 :3 0 1b :3 0 16a :2 0 16c f7 170 :3 0 170 2 :3 0 fc 170 16f 16c 16d :6 0 171 :2 0 2 3c 170 174 :3 0 173 171 175 :4 0 14 :3 0 100 4 :3 0 1 3 1 7 1 b 1 f 1 13 1 17 1 1b 1 1f 1 23 1 27 1 2b 1 2f 1 33 d 6 a e 12 16 1a 1e 22 26 2a 2e 32 36 1 40 1 3e 1 48 1 46 1 4e 2 54 56 2 58 5a 2 5c 5e 2 60 62 2 64 66 2 68 6a 2 6c 6e 2 70 72 2 74 76 2 78 7a 2 7c 7e 2 80 82 2 84 86 2 88 8a 2 8c 8e 1 99 2 98 99 2 9f a1 2 a3 a5 2 a7 a9 2 ab ad 2 af b1 2 b3 b5 2 b7 b9 2 bb bd 2 bf c1 2 c3 c5 2 c7 c9 2 cb cd 2 cf d1 2 d3 d5 2 d7 d9 2 db dd 2 df e1 2 e3 e5 2 e7 e9 2 eb ed 2 ef f1 2 f3 f5 2 f7 f9 2 fb fd 2 ff 101 2 103 105 2 107 109 2 10b 10d 2 10f 111 2 113 115 2 117 119 2 11b 11d 2 11f 121 2 123 125 2 127 129 2 12b 12d 2 12f 131 2 133 135 2 137 139 2 13b 13d 2 13f 141 2 143 145 2 147 149 8 152 154 156 158 15a 15c 15e 160 3 14c 163 165 1 167 4 91 97 168 16b 3 44 4c 51 1 4 0 174 0 1 14 1 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4e 1 0 3 1 0 33 1 0 3e 1 0 13 1 0 2b 1 0 17 1 0 2 0 1 7 1 0 1f 1 0 b 1 0 f 1 0 23 1 0 1b 1 0 27 1 0 2f 1 0 46 1 0 0 / CREATE OR REPLACE FUNCTION wb_rt_getError wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 8 9200000 1 4 0 22 2 :e: 1FUNCTION: 1WB_RT_GETERROR: 1THRESHOLD: 1NUMBER: 1PARTITION1ID: 1PARTITION2ID: 1TBLID: 1PRFID: 1RETURN: 1AUTHID: 1CURRENT_USER: 1PARTITION1: 1VARCHAR2: 130: 1PARTITION1COL: 1PARTITION1CNT: 1PARTITION1DTYPE: 1PARTITION1LEVEL: 13: 1PARTITION2: 1PARTITION2COL: 1PARTITION2CNT: 1PARTITION_NAME: 1PARTITION_COLNAME: 1PARTITION_CNTNAME: 1PARTITION_LEVEL: 1PARTITION_DTYPENAME: 1OWBSYS: 1WB_RTV_DP_PARTITION_METADATA: 1PARTITION_ID: 1TABLE_ID: 1SELECT partition_name,partition_colname,partition_cntname,partition_level,:n + 1 partition_dtypename into partition1,partition1Col,partition1Cnt,:n + 1partition1Level,partition1DType:n from owbsys.wb_rtv_dp_partition_metada+ 1ta where:n partition_id = partition1ID and table_id = tblID: 1SELECT partition_name,partition_colname,partition_cntname:n into partiti+ 1on2,partition2Col,partition2Cnt :n from owbsys.wb_rtv_dp_partition_metad+ 1ata where:n partition_id = partition2ID and table_id = tblID: 1WB_RT_GETERRORWITHNAME: 0 0 0 90 2 0 a0 8d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d 8f a0 b0 3d b4 :4 a0 2c 6a a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 a3 a0 51 a5 1c 81 b0 :10 a0 12a :c a0 12a :f a0 a5 b 65 b7 a4 a0 b1 11 68 4f 1d 17 b5 90 2 0 3 7 23 1f 1e 2b 38 34 1b 40 49 45 33 51 5e 5a 30 66 6f 6b 59 77 56 7c 80 84 88 8c 90 ad 98 9c 9f a0 a8 97 ca b8 94 bc bd c5 b7 e7 d5 b4 d9 da e2 d4 104 f2 d1 f6 f7 ff f1 121 10f ee 113 114 11c 10e 13e 12c 10b 130 131 139 12b 15b 149 128 14d 14e 156 148 178 166 145 16a 16b 173 165 17f 183 187 18b 18f 193 197 19b 19f 1a3 1a7 1ab 1af 1b3 1b7 1bb 1bf 1cb 1cf 1d3 1d7 1db 1df 1e3 1e7 1eb 1ef 1f3 1f7 1fb 207 20b 20f 213 217 21b 21f 223 227 22b 22f 233 237 23b 23f 162 243 245 249 24b 24f 253 255 261 265 267 268 271 90 2 0 1 a 19 26 :2 19 2d 3d :2 2d 3 13 :2 3 1a 23 :2 1a 2a 33 :2 2a 18 3 a 11 18 :2 1 3 e 17 16 :2 e :2 3 11 1a 19 :2 11 :2 3 11 1a 19 :2 11 :2 3 13 1c 1b :2 13 :2 3 13 1a 19 :2 13 :2 3 e 17 16 :2 e :2 3 11 1a 19 :2 11 :2 3 11 1a 19 :2 11 3 c 1b 2d 3f 7 20 2b 39 7 17 c 13 7 16 27 32 5 c 1b 2d c 17 25 c 13 7 16 27 32 :2 5 c 23 2d 38 46 7 14 24 34 3f 7 15 22 28 :2 c 5 :2 3 7 :7 1 90 4 0 :a 1 :c 2 1 :4 3 :2 1 :7 4 :7 5 :7 6 :7 7 :7 8 :7 9 :7 a :7 b :4 e :4 f :2 10 :2 11 :4 12 e :3 13 :3 14 :2 15 :4 16 13 :6 17 :5 18 :4 19 :3 17 :2 d 1a :7 1 273 4 :3 0 1 :3 0 2 :a 0 8b 1 :7 0 5 30 0 3 4 :3 0 3 :7 0 5 4 :3 0 9 56 0 7 4 :3 0 5 :7 0 9 8 :3 0 4 :3 0 6 :7 0 d c :3 0 d :2 0 b 4 :3 0 7 :7 0 11 10 :3 0 4 :3 0 8 :7 0 15 14 :3 0 9 :3 0 4 :3 0 a :3 0 b :3 0 17 19 0 8b 2 1c :2 0 e :2 0 15 d :3 0 e :2 0 13 1f 21 :6 0 24 22 0 89 0 c :6 0 e :2 0 19 d :3 0 17 26 28 :6 0 2b 29 0 89 0 f :6 0 e :2 0 1d d :3 0 1b 2d 2f :6 0 32 30 0 89 0 10 :6 0 13 :2 0 21 d :3 0 1f 34 36 :6 0 39 37 0 89 0 11 :6 0 e :2 0 25 4 :3 0 23 3b 3d :6 0 40 3e 0 89 0 12 :6 0 e :2 0 29 d :3 0 27 42 44 :6 0 47 45 0 89 0 14 :6 0 e :2 0 2d d :3 0 2b 49 4b :6 0 4e 4c 0 89 0 15 :6 0 33 :2 0 31 d :3 0 2f 50 52 :6 0 55 53 0 89 0 16 :6 0 17 :3 0 18 :3 0 19 :3 0 1a :3 0 1b :3 0 c :3 0 f :3 0 10 :3 0 12 :3 0 11 :3 0 1c :3 0 1d :3 0 1e :3 0 5 :3 0 1f :3 0 7 :4 0 20 1 :8 0 86 17 :3 0 18 :3 0 19 :3 0 14 :3 0 15 :3 0 16 :3 0 1c :3 0 1d :3 0 1e :3 0 6 :3 0 1f :3 0 7 :4 0 21 1 :8 0 86 9 :3 0 22 :3 0 3 :3 0 c :3 0 f :3 0 10 :3 0 5 :3 0 12 :3 0 11 :3 0 14 :3 0 15 :3 0 16 :3 0 6 :3 0 7 :3 0 8 :3 0 75 83 84 :2 0 86 41 8a :3 0 8a 2 :3 0 45 8a 89 86 87 :6 0 8b :2 0 2 1c 8a 8e :3 0 8d 8b 8f :4 0 b :3 0 4e 4 :3 0 1 3 1 7 1 b 1 f 1 13 5 6 a e 12 16 1 20 1 1e 1 27 1 25 1 2e 1 2c 1 35 1 33 1 3c 1 3a 1 43 1 41 1 4a 1 48 1 51 1 4f d 76 77 78 79 7a 7b 7c 7d 7e 7f 80 81 82 3 66 73 85 8 23 2a 31 38 3f 46 4d 54 1 4 0 8e 0 1 14 1 e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1 0 2 0 1 13 1 0 7 1 0 b 1 0 3a 1 0 1e 1 0 41 1 0 25 1 0 2c 1 0 48 1 0 33 1 0 4f 1 0 f 1 0 0 /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de