create or replace type sdoridlist as varray(1048576) of varchar2(24) / show errors; GRANT EXECUTE ON MDSYS.sdoridlist to PUBLIC WITH GRANT OPTION; declare begin begin execute immediate 'revoke execute on rtree_index_method from public'; exception when others then NULL; end; end; / declare begin begin execute immediate 'revoke execute on rtree_idx from public'; exception when others then NULL; end; end; / declare begin begin execute immediate 'drop type rtree_index_method force '; exception when others then NULL; end; end; / declare begin begin execute immediate 'drop type rtreejoin_imp_t force '; exception when others then NULL; end; end; / declare begin begin execute immediate 'drop package rtree_idx'; exception when others then NULL; end; end; / CREATE OR REPLACE PACKAGE rtree_idx wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 9 102 f7 jPkObJAz3IQH0sF3NsKjkjlnX44wgxBKLcusZy+iee7VYXdGVLQJYsRtcUYAwr8HaUzvAmIt pU7pmQtr3Cr6RzRZ0ItGgEBDYUfHRYe5qX8hp92iXKfIURdE0q1npJU2HjbYL9A+M0Y3OPbz 5F3+Sl8QRCsn6qni4/s9IU0H4KS1yPbe3W97I2Z6vndckrDRz/kJcsJ0VED+8D27IoiXqOWp 2+LgYsdv4bKXblbwQ4v7o3p6UQ== / SHOW ERRORS; CREATE OR REPLACE TYPE rtree_index_method wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd d 719 268 h9w4EWhGeFZVxd24Aze9Eyu5/i4wgztcACCGfHTtKvmUdqTdU2t9PKH3fW2eusA+xSy3pzkR Bxn76Qf4OoCY4gVx4Go+Ufro1/4cOlns/rIVHgUe7shBqiQc+eicagXrT4Bp97E8qUqifVeV qTbFqQ9VjItWcmWpDo0M7L9nJxOa0W3f2xg7QGV71zzapWAFD4U8fwkmIUBop0XCN6+AQEso JAV4GTUFpQl8koSF93ZTVGRGI3Roe9baHqKkhEg9pjHGDA+moYj96SM7feipfqiAj6RIeOWs g6CIr87DZE2m9RP75uKcMQZUgPcuKXxUqIZsZc8B4uLmtsXULUghGPy46CxJbsHwddI3oea2 aIZ2H8jb1FlpdjI6mfm0rfbdXzQDT66a2TE7bsVeXGVl71z/UEnf1QgxRUhQ0SlagG7P6/o6 aSOVFV012gprTHbteuDmWVXrw+9k7Vjv0pg7CNfIsS/svt4on1oS41r4vkI3KW37wNXknM4t DdH6rOSqgNKn0iKqBg+V74RmwIsvavqfrG+Y1EggT+CchSOQ2psFfBSFd0CMJKw2g5o1te7w d6BXVauM2EWbNafUR7mR2ZgstabbVIzs / SHOW ERRORS; create or replace library ORDMD_RTREE_LIBS wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 16 2c 61 Nq8Gnj+8C0LYUxmmU3u6TXp8etEwg04I9Z7AdBjDpSjACDL0KJ69wDLw/gj1nivnvZ6yy1Iy zLh0K+fLUnQI9WHJpqakZHRX / create or replace type body rtree_index_method wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd e 1135 467 M/ajoW4WHPVAQA9J/hNRYQdPo5Uwg+3qLiAGfC9V9k7V2Iem+vxrxjszcH4dh0TaDZDhsOc1 Kzt3eeoh1c1ymi2QNgm8DINaFNuI0HMZE1hZilbuTWS0dDsYXEEXrpbZ5A8z2pYcD5wW0xvm 54gM2A4RyPInAvFaf8VAaJ7evhwvly7qdBFWX+nFDYVHR/ADaXNPbqN4aIT/DFchxCanWuiG IrEWzrtOa8iNoUP8+NCkQUXXa0hbudpThmBGkc8jBSmBuVGLCbmoXCW0/bcJtNgIOXHCeXa/ zKD9O7/cKkmnjOLKgf/kU8gdAszm0rQOW1Ep4326X1HVV+TmKA2t5P5xIaHKOQg+fjXxtCBM 8X+AsZ2ck2mRLZfB6T/NLJVRZPRBqGMxdQGDJ/+CBE5WUfRL7zZaYjBOHUtsuERBLsR21Fov /h3sbLaJVGP7ZNwmlfb0FfOlFp7Y9qgHlN0jGTw2pgcAg4zi1ThN53TSy07RGu6DuYZMmWHJ c3Py2sv6SSgUYAuLz4jowlIPhmKN/5QpKUNiD5RibfVuWq/h+/Zc8s89gVPQc8KQCraGf48R oRuUA67I3lgkwTvBJQeRns7l9h5lpHehCjbNDLCkdE8Tntk9Hk9k6FPtFkCT03al6zqtbZDg gf4Bf7WSBH7QDiE4XcfrNA3FvHPisrKAjIYWsuE6rC4gem7YQPRMkqcpo5TqwXrSiFwsLTXX 99LvfxZTlnNRUCHYmq/bnccQCw2LDThdcwHFCAo2dZwHKeS+heoPpIz70Ydq4goBrdPHraCM O0ITdI8bLBPNlz1bDCmof+439i50Devy6GXIzy/7tu+V3L19kO648uFsgTSix5/8oBLMrpiu vkGQeyjjg+eiUwKBcvr+9MiI0rm7tsR+pwxYsfmWSEGaGEISeVherW7Qxpv6EGHyS7YITVXt 3dwNjJ/cqHb1g5oK2lXygTP9jaPuCvKgtrbOVYCEgo2MmcK4R+1dBZNXj6dKRQkK9CbVcAOJ 5rJ48GReBLgsidejI9495I0fbcY8UfDG1rgZNc8NF9CIB9nJr/UwajrAufN72wDwje5VDFi6 ep28Qw8VaGwQ83z7u/iYILX7ALUUPg== / SHOW ERRORS; / CREATE OR REPLACE PACKAGE BODY rtree_idx wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 1f6 168 Cf6UZmrEXk1cJ8M5WZ0CRAirEDwwgwLIr0jWfHRAvwKwpS3rUHdSdoOocMQNOdxDNoNBU9gH hwqkM86ZL6MaeaNm6Twg+G2quy6BSGE2Y5W2cSRkwceqOs7hhiWOQNlBdzDh3hPxjoeacExG jn6jJnq6+28aC5q5f8M7tKnavhdtlNB72dTJDl9QiDufYE5W0vk/fvCQJmuvN49QMy4mquqZ pD8rhOwUvaG//Wbb0K82FjorAd+vSNs5f8qHUaNWoM8mjaABobA1i6dLOYHyd665/Zvabb8F WirwBQTtF7OjOWpXlfGJtYDgUhr53Ox+chr9J3zEGGoA6fVHt3DnFdq11sYG7v1UIr/h / COMMIT; CREATE OR REPLACE PUBLIC SYNONYM sdo_rtree_admin FOR mdsys.sdo_rtree_admin / CREATE OR REPLACE PACKAGE sdo_rtree_admin wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 9 8ce 2c5 5ZHFQ3PcqBoqToUrpQGv5dUQwDEwg9dcLUgFfC/NJ6qV8H/K9YX89Btyb/MYw9CAsbnmjlpA y3k3oLXQQV1T8XaVKwsoQ903NL/Pu1WQw9VzDt/nnRyqi8Gacq6uOh6G/iAkZ2zRO/uQ41DH 3PO9w25ywaYeXSoFjzh5pO9VeXzDcADDG7mGxhHm4ivDZ8fPtZJx027i8pUHG7gKWpwYuZlL yZwquw77OYw7gTm/wHxASi4ODoTgyhvbaGDBnr506MgSnZ8nHSJc1RoCkcpdolXH2TcWu2S2 0j9/xC9lwiODq5cHR0Wg/+f4MB8y9I2b5RX7HvOMWwpj1CdDQHx8YQ253Qjgb/FvHq8S7HvQ /QX33igMvjuhecVsNff6J/9G9ok5PRbmh23VjwN4zYfZ3MKW1AB7C/Fp5CAue5+Jolf9Opp0 J0YueH1fLjtaOlo062MTdfUGs2OlztO18XZ+idGChSu/sHgn1IzatztImznwG/PmpPxdjgvo L1cPAGSwTcRtAKMR1swPf8uMjp6pmUuLPYq4beKaywMx2JwNK9thAQUMYoUN8kpEhmjhYJc6 v0g56CzbGHrEtawQO15Gn2baAsEVQ5rK7Zo/Tkn7JxV5+V0wmubRKMahfeC91garlcUeyBlB hy8jXtUAGZGQCFvLH2CwjPV2iKv9dtLoseyXwzyWJOT7WMSBng== / SHOW ERRORS; / CREATE OR REPLACE PACKAGE BODY sdo_rtree_admin wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 1804 7b7 iDHDBI4q8/EdZu7+U7vKfh6WklQwg1VUedCreC+56s6UKxqeEWFJjyXl14EiVpg52AUf4BOZ 0tkYdrpEKaa9WgXDOgikBZhhnExwu9HlURvzOACWHkKLWAh19B5Vvu9fOS0kgPhD3zGkn97s VqcePTm+2DGiEVfwetwG57Kh3X950Lh2ZtNrUBfHn5XkV71bdzXgvg+HW1vGquacVb2VEpwj C5wzCvXjJAx6IoQVXIoSRqIiQa/mjdG2GI+WQcCirZVX94Oh4zpXM6TIgGrdpGsRq8t8zalb GDqJ7LLKFRq6etbOZnjIKPf94NIn7UcvOguBMFq/ZBoWyh38Ja0YJiyS9CNs2D5Ju70s75ZK VzC3mbacrNWlR4MxwuEMEBXUEAa+eujjUnuBMD7mvdiv/qxhprH6qP/1DPKIRUpAOlG6Gz3H TZbFDN2ym7C/8QFmM+fOZrNNx+t+b1of6ZbvcfR+DSaBDREq3e/TAbyELF4j6UwVuOF3Nwd1 YbprmsBpDLyMQ+S0mLkPtXRXjqYnslWp7qdxlfeqXt1aRuKfffChjx2e2Nc0f8tMoQaZYyuR QOf3mNYOEUDPZl4O4O19AtOa38RLf77TKWp25eNL5RVeXP6lCFINcaq0zU9UMH2RQ4hxirvG dHkRyxHwpoDvIp9WRm5mo43LVvBo+2dYhlgT590Yn541uuLNghQMXHW9FMf/sx3PEAPShfbT IeF955y+LbpitfZIjqPbginMst5iQIm42OnTbaRJU6jEN+/5eifPsuB2sxXe36vldlQb+jSm 1Q5CznW2ctgincZ+pymaB/XHzk/EdYYzBm6Mrl673CfC71xi31hXl/KTDSsF8bUbITNLJGME Lgb6Ibit3BF2Tl2VwYMtXICl5qNlHMB3hbEF7Ui1Lp/hmaGa03N3HhfTlgayd2mKXtXIRtsT JTlQlmsw5w+TbvSRpqxK8J6fvO1E01s3JUYWHj4YrTnAR566L20GTMlqe9OorKSr+jIcvRel nKPu/qr304K+FluEd0iufQCu3T2UXa+YDBS1Bd+GZJjL/DJImKQWqJCNJ4KQjtnl1s4EsYic l2hpA+sTD7KIo5FOweHcvaCqznXiH8uj9OCAE5V7VcRKYFaBNgOU2z7GCl+UqUKZf3Zw0IxD J6pUeRzLPC7evqOwE3MnmDf+diLap5HEVRxwT33ZnOGtugnpSBStViJ66BFaOLxMeiIbYEvc KG1DBktpi7IB/j9faxtfJTNkLkWExH15KL5Lee8vCPSBvOwf9zppWG9/vUg61shs0Qt1m9WN FaKRavIXN8qNyRRuNlc4u+EB5V7sk9S2dkMyN0DC/PvrPtbMnVBJDZDiYghh4iOeBjCsZS8H dRILzfeiejwCjxEz2q0xTo6GiO7hJO2cu4x1KIbe36EfxcNAQp9RPLnpEtkoPsMt0Eoz0SfG NPuDyzQPPMIG2iWOPhbl/MFOvWCdVVGHxAViiYA4BafRNmkN5KO7pVvu/GAS+qFku1mTmZf3 UD9ncN+wHltq1xolYWivgxAwLe8dlqqrB5/zIvQQxWL80zHDeKE9gEYBfR7RRhe0E+a7BC5J ItLI/GiLa3VWg69YYF+bigHYArWH/lna84oCsOgjxcQ7t7ZY0Fj+rDjtm4XHL0VwGxnsNs4c WzOP6JPR7eb4i6K5MxViZP92nVn+KJqLBKp37NGyCERbb18tgJv6DaZIlVdcprE+ODtiShQx DK7/ozPSIHLqnofjenW1SB81YkpYdfbeCuXxneh3s09pz080mc5xo3G8JHYmn/8JSPuwgcGq JZxz7AdB3VOeGCquBpMuvmXG7El8PGJHYTwwow9yL6s+PVE8CEPzo7ATMLgYQTQhGIZhSJrl HLMuXsz0ALW33TPr6jTGKtnqoJIpKjyINt9vg9EPxYgAWHRNKwhttoV2fOIs8X2LmKr7z2Y0 sQ== / SHOW ERRORS; GRANT EXECUTE ON sdo_rtree_admin TO PUBLIC; / CREATE OR REPLACE OPERATOR rtree_filter BINDING (mdsys.sdo_mbr, mdsys.sdo_mbr, varchar2) RETURN VARCHAR2 WITH INDEX CONTEXT, SCAN CONTEXT rtree_index_method USING sdo_rtree_admin.filter; GRANT EXECUTE ON rtree_filter TO PUBLIC; CREATE OR REPLACE OPERATOR rtree_nn BINDING (mdsys.sdo_mbr, mdsys.sdo_mbr, varchar2) RETURN VARCHAR2 WITH INDEX CONTEXT, SCAN CONTEXT rtree_index_method USING sdo_rtree_admin.nn; GRANT EXECUTE ON rtree_nn TO PUBLIC; CREATE OR REPLACE INDEXTYPE rtree_index FOR rtree_filter(mdsys.sdo_mbr, mdsys.sdo_mbr, varchar2), rtree_nn(mdsys.sdo_mbr, mdsys.sdo_mbr, varchar2) USING rtree_index_method WITH LOCAL RANGE PARTITION; GRANT EXECUTE ON rtree_index TO PUBLIC; COMMIT; CREATE OR REPLACE TYPE RtreeJoin_Imp_t wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd d 4fc 1e2 QtAu+MVyjxn8ImGrtx1xlU9OqNwwg0PxAK5qfC9AkylkpXValNOU/bcLD8PE9KRVkN7aQvzd 3QdptZ1XW8wqXA41S+76MzoQECwou3tpMDAFu+qW0HL6AO3o1iX3nP/FtvOvxxg2TSEmaTvd pdh1Pg1AkObtPrmXvm7jKtqM/H2ymI9cS9Qt4qvIpsA1QMTFoiuF50ue/0mxn/TBOlvp2vLn DX4+j3H0VQJD0jvAIh5Im4D/urR7D1uzh9nxzuB6QWqAnFChzJtHxmHh5Hdh7Dxuumb3W/DJ JlJ/d5MGoqR16x+X5jsLauA8IWrBCZP8L9iC7DhRYKPEdcrFJCMC3fOu/MjZb5s/kRwqS5Nv Ni6QTICABn9+EVB1bR3zLOG5zYVAFDn/l+k6jHdZtudKJpBjMkgq/TfiF/BXKxDctaZFJg4u QB7VDmDUPNaJE3OcfHNAjBxPNeaa7yHVu2QZ+w6YxVQ= / show errors; CREATE OR REPLACE TYPE BODY RtreeJoin_Imp_t wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd e 9f4 374 0pZVQ18uulIZQ2wEp86R4i3AkFAwgw0rDCAFfHQZMvmU5q69cDZU4gD6ZZBNA2yEUbFdkXRM QHlUBajXtcYU1FJWJCV+HkbdyM7T+ruML2in3dOQSFitir+YmMG7rg3P5FwsdaDzx9kQVsCJ rAGN0xYN4HuU00Lx1l4EbpM3/ejVkTmy3ZCn5afpkwtHogF1VYODZ4thKxN1zEdtDJsoWcW7 xKUfoY0VYOVZ2pr+SK1zwHG7PXmOTKwIyeXF03xJmqwF0H3Vn+yuaOMqeNlQlg1UBdOisaxj yAjFgB9WcoTH6pNMq1pjj+fqklM8YmS47PiHiN2XbuWl4eZsN43Dswg/Jf57ncpwViu9N7aY i8a8ZPkDXyZ4sErOMvzyaCssBwKVFwV8Ojo72eHDI/3wUBRZBnkEZS5K6t6zF9vp0V+zDlzc rBmjcakw/0XdkDeBUMJuClyV6t02ocBYBEhhWROgWvYnh82RMxFkMPuKiwjZ+cbr2e5O+biE JRL09hug5rTKvfJIbqisLX480mHMxtf3VyUxmM8+Us1LNV70PFBOFic3EWt7rCXHrdWcVXOg qO6MAn6l9KytSM/cJW/aF7sVWg2rETkiYhodT8u0XiKtTZTirgbIptYwED/SrED8fMDQV9ZQ HeCB4P7Sc6D0x3nQoVnvij9EL7YH0M85FjyCmUKLQnp7lZd9Ev00YWS8m9FKRBq43z0Nmcpe SXUH1n86jzr1b4mIAHyJZ2g2shxjP5MXT3jlffzmBIbqKDCqvJ25yyia+T+8TGNVc13PLAW0 AHSIn9h4evBSz24nnOMbwHlrAmNb+izz1mbzhR++uN+YkiWq+wjuwU7ZubXWV7MjktUfOis0 +LJ/xVxL / SHOW ERRORS; BEGIN BEGIN EXECUTE IMMEDIATE 'REVOKE EXECUTE ON RtreeJoinFunc FROM PUBLIC'; EXECUTE IMMEDIATE 'REVOKE EXECUTE ON MDSYS.RtreeJoinFunc FROM PUBLIC'; EXCEPTION WHEN OTHERS THEN NULL; END; END; / CREATE OR REPLACE FUNCTION RtreeJoinFunc wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 199 144 RCSOpq+cFpgF0Z9BMxahatCrSQQwg/DIf64df3QCk2SdFQv3xRRIAZtsvAbxx2bGPmiJ+zJ9 CRQ2tU9xBwlvw648+ORB2HhvUtTMZ50iKAdVxgghP08Z6kyxr2X26o6bbgoltDx2Msc43c5T Swd9pAMwIwuIhiwZtdkLZkQ+62dFNw9CFeTgx2a0jEUXd/mXBgM9boX72UTWsPMMS2+UFT15 Er4bbHLL8Eh/BMtzskoSVGLuK8PK+FQqvMJykS4uTQThAvKshMpUeK/OaLsJXXwdl88zSdyO VIWE+la6aV5RTJEmemMnrr8knmE4NQ== / SHOW ERRORS; GRANT EXECUTE ON RtreeJoinFunc TO PUBLIC; CREATE OR REPLACE PUBLIC SYNONYM RtreeJoinFunc FOR MDSYS.RtreeJoinFunc; SHOW ERRORS; CREATE OR REPLACE PROCEDURE reset_inprog_index wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 7 161 11b /y2Sk78OMa1Yuol28mrfzha8VeUwg43QmMvWfHTp2v7VVhvIdUWfwLaZZrM2WFDG2+HlBJIv AY9O/QKAKbRW99DNE25u8MqTZTWxNBO8JyxkuULH6lV0a6324Gmr3IVm6RmVus67FmIpCd56 JXsbm3/lpkVU4PBYZIJ3ofS9NwQMMnBd1QSngJMtAVGXLRV4EOC4ZJi8EsSBLzAwK99EOKAy LRxdhUj/AMxnV3PPJ3JmGXxAk8PFNzxWyu+QtPVBc0XbnYfZPBhKCrM/Tvs1acNH / SHOW ERRORS; COMMIT;