declare cnt number := 0; begin select count(*) into cnt from obj$ o, seq$ s where o.obj# = s.obj# and o.name = 'JOBSEQLSBY'; if cnt = 0 then execute immediate 'create sequence jobseqlsby ' || 'start with 1000000000 increment by 1 ' || 'minvalue 1000000000 maxvalue 1999999999 ' || 'cache 20 noorder cycle'; end if; end; / CREATE OR REPLACE PACKAGE BODY dbms_job wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 23d1 b7c I8WDJTJmMs07TGNr9+F62uQ8C7Mwg5Wr3l4FYKAPamS030eFJ47QUhET4clgpzxgNSV71fqv TyEaa+ugFPWp0nXuxv7N7dUMwq2DI+f3Dbu8T9tmX9xqrWBe02RQB/5PSPwPZBmMGrQxNeTr znJzRQ4UFVLpf3sAENZOQ6btqF6JXRHsXahMPaGHBq3ohSSJ53Rsbheo4En1b2AEslFn4PYW +gFzxGoge9BbpSj35X6lgorsaBSCZ4JH37V4CptNWVpKyaEcsVJUrHduXWVZWGHZyGBJqKT4 4wbCUa0GynCEY/XDzEJDnidH0+qTYfwCpqusKrBIucHO2I5b5LGvNkNc7OVOPkFJvkAuyYWF TA5uiXYEjUm0pt4NjV1nZUHJ6Uw0LgeRN06rSG/b09cBC1W5+GZa4jYx6VqZcQfpTJR1ywSx pkJ4H5wfJFVRE50gIm6ah92ynKn5aFW94Dj7hUN8SZFrVYZqKaunBz+8vJJGIs+tndLhjLoc p/rTBa8YLyJtpaz4+aS05/NLjmLsM8KJr4nTexo44fzd/tMXBjyPQ849Cu0sNfQgehtLnx1x amKcFxwFDw3Pf0DOajKiJcXZY/cz4bYE+TxUht2e/R/wxmvNUs9AjOXbdse2inScs6Eu+phR snE1vcwnULwVHid+8AvVszeJ07jW4ytiaRJuhMkEbXaIEyJH6/iGzOuM3a9o3j+cAYQMDtz1 0t6FQRY2lKCLocwDWY3yv96zAVFIrzXD6EunKGaUDb+eXuXpSAPUfKYIaiXidcq6ulhoVGwF +2jgxFwpJbBx8vOTzVxAPfAEgN7nxS1vMRFS3d67L0J5Q2CMnZ28ks0GgqCj8QZ8FxZsO6Ub 2HIfqlU82OH84Sju1NEPpoTiZUmpez7YlICLRE/qHO41ln3GeZZKBdtQCx0Ecx/zfkSlSgQi 29C97hpN6JMJZcp/Blo3TskUn/0JRrxgXr1Q1nD884RwHwDdRU9Xd/OOtUvyDOdRlpychyyC CU50yPL651x9A3wC75AKMRgFcAAdj2F82Fl3gSEqPsVZey8O+3jQXFAdO8wOAbc/O29oFt32 H5RTXfl1WljKRRanv1c4QGbljsI/dsGrmnv/TCzVtUzBJwvZivmqkKSK9Yz+bnoSM3QRbwF1 gFNiJCG3zN04F0ZlZ3fv9F9Ffo3qk/ZDrjFH46CkOWSiu0ygmv8ruS+QO2YJQwEMfNC0Unrw WmGmt1wxw0ttPufes1X4Gb8duqL+5QSb05UQjQfekPFCzNTrPbiHAiHijLZ2kByrNvpaKtg2 4fPnd4obwxne8RtD8qlOZfo30IM4XuQjKAJp/omMOYNsD9aj42mG72FE3TmPjrTNQDEsvJlp oSdIHajQuyyep1diX8jGt2Jj9TYAI2WtMVA7XcNdz5PyiotwRpFpFSSrqI835eiA31bCPaFj 92y3dJa4jBmU19FR7EpB46JJnwF/qKhmtPTnPwzdH1eV8+fzydhAiaKLr1/xX4As+GHVmWaY P8tsLfLDxNp7rFi34krQjebFKEqzGREhRcRY/saGbxPyiK+e7iE2VkF7cVT36XG0Q+J7eAjX rkmF1hqhZhb1R5nI2kFinBTLyT6lBaCpR+DpXNhd3TWOdP+o4ua+L4SRBt/SeWli7aM8TIbv PbRXjWdTbC//RoEg8otc7jL1e7eeUecK4uf3lj94T6OFh4XkO/juVq/eNFs8tqx0XHQF7wQq V4Q9JDWDOTKBaYC0hAHEekhKn89LbQpEBbMn8YTubQhY2sQpmZR+W7YQOuHUFxAiSY9EHA6D Mwas+iNwvQrUxIvdYFJgpwR5HLR3aQt6J3b6DGftDvrCL6LkyWMvfthq0UIOkl3H5HU6LRAV Z1XnYrZgeLjGorMHS+m3wVLZkuQzeRnO+5eptG8FT15SSXwsfMpIw/diYlyFMc149+vI8clO 84TWpejG3uzi4YmR/QA48OU9M5ImnmcuXGHVGpKN6XFdD67I7C8S/GLBqJPJ7BrKRafPssbV pvih9SDc7HUwU0ViodQi0MXFkPMRJuvCUeXIQg7REL3XwFSBY3mCQgyBc2HubYD1F2e/q2eN SweYA4x0/JWxnogNJGjGxjlVWCiyBW/2oCvw+d1BCcCe7c7MQn4RVD8/dyL4Uxovm1qC45YF yTk7wKABk5ia8p6gJ7ffg9MjXsMXMm/Cxgbg/y3/QwuJ6Gw6rcIcsE2koLLcwzIF6AXi93M8 nbUbEnJVw3WTevsQUUPHarn0ktsvrlPYzskHR2/PC4eae13I17FEScvS+ZXBUvhCjr/+awxA xtuPug8vJ7IELri+9tSs1FZPfcKT2aVYVwk+4jwR7qVwe/ICKsvqaJCaxGg2D1uXKt8AmsRB vvw4xjEjO69FCb7Rdne6u7TJXIYDRGtj+qUUIEK3UF7dtGbT6OQy0RKbF4cpRXJ6Ek8jydWt +RaKryKKJbxuNI9X+jq4kSwDXjJH/FgQehzw5PgzBIhUz1KgDVzRfxKwxKxy2VYSiMZbSUmG c9ZWrRaecihuW8+OlgkzBnENQcE3Wyz52U7kpFV49HciyCM25kyBOZBEUg9gWus3KpSEof+L n010lQBES0GS1gLuxhOWuyQQNKTdgV20mJiGGoG6lJbOTpxOulelzvPvfv+pvD+VZa287QYf Hb2Xw76YtmWgBdlOAG1yxnLEH7Gqbg8nh3AdnD1cc/g6gbK44I1yJNJZwYMpbYr7IwaFucZw kwWnmUjELUOGMcVUOzIg+wmZwp7xTLpCzXoO6iSSlpbTvLs0XCDyXLpvtpV64hfeVw+u1/cT AIvQYFc0GEmhXprBKg+h6FdOl4yVWECzKW7mzV/2uTtRtMpYQkPG2vDVnDnWC/pIynlNTfLn bHd7qsk1yYVk+fvwtb1R / CREATE OR REPLACE PUBLIC SYNONYM dbms_job FOR dbms_job / GRANT EXECUTE ON dbms_job TO PUBLIC / CREATE OR REPLACE PACKAGE BODY dbms_ijob wrapped a000000 1 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd b 4f99 161d Apzr/VszeTkfO/8477AD1wTYJ+Ywg8129scF1C0P1w9SWFcdDkAECZ+j6hh6HaxJnt/nyqYW k3Os946tzGbZHAzcBYhzzrntLFepymxJWNx5y0R2uTMzMzMQmW/M5BujcCHZwbB9xk7+xNc9 liz/zAnwL6yuzIt/QWTyXxk0QkyJ1V2M4I1HzPFrz1yMk/HpQ963kSqHj9NE+HxGdBhv2ef3 PJt8GH+bhsjQBxzL3VzzHY9cAgym8Oe4knJGHErIHg/MG8bS4IzMoT13gATJwZktYDuT548M H2UnOzadLnBsZE6IhBEv0QdCiIafuypX3VlI4NG4RBaPVuxjMLyV0a8wvVMNzDmKb5ceZ+qO IebvOiyk4sJT3Jt01xcubpZtTdzJoex3sE3bgeVHaWGj/6bCcFr4hMELHfo9COtmxYxsQPTG xsxFFZp3sEQZgHQ7Tdiwdo+8fjGUXoqkDr32QcGBoD6bnoiQazLEVeyFEMM7gjRaZZLDEFxX lVLwwoZ3sOMCGdkI25nn98AtqWplD/wMj+TA5q0q1t/1qTRtKLskQVVMkA8PI/jvtkxUNfFc MimCMKib1Ifj6KXu/bd25f9LozZlyAih9co+/2+B8wfTDhcRl0CGoBXl+EhybuGDgnnAf3Pi 9iO24B/hqeY5z78WuUckfng4MJB4foLkJyrrUuuz007N49SQ3t1/PUk4Wetb9eWPwC/v0Tzd dsrvXiEcbZT7yM4WxRAYJy8OIXKZ/RKfCGLs3I7fGiyYhuA1syNgmPGf5N/URI3vcG8v7DRY gDJ3dovVBFb6fhBSaexdY85DRu6uGw3pCeuePIA+vRWZS6J2nQj6AYl/PdQWH0pBVzIs6qdC QQYWmXXYbbPXZeWG72eRjT3yCUnodfsLf1pbfXzhG+nzMTV/tepvZFLMGspzncDz9f+ARMJ7 O9TGru9pXsZT81XFISPAFWLn2HXvn8qvitVhNl1u3brTS5SHwI3sUszjs/fcXSG+fwEnfEVO McInpvQ5nAGHStkWJny+ZAjxKjramHIPirx0ROuZSzWP8ckysupfvTGA7OOTCfh9fPBvq4Co aej83y9610L0LfGvSTK9j8/hQ7oEq8+YmZkLeTtJN7yHy7Sw5JSg0mswdGe4j3HIvvEYZKIP 8tkAyva6BQuxjkErHwek6RFCl8nq6NBo2n4faV//98NQeC6Qjjf3y5Xe3bSn/BhJPm85tQgq prmK/Ij1UmWng2xE0dke+8q/RWcnsax0fqKPaLt7D1YJeolCgTtlMOqepqQpcK7ygKCET59L Fh6bWbslBl4e75z7vCTOfeHXhk0U4O0KMCfpVb/rSWgfcoVardSqIr1ZSAsIN3JruHdG66Jx LOWyrXYmtYVVXuK7hYGxfak1UP7UH2qsN202Nnsa6PYC9jxr7qirmIl2ohtOhmBTtNEyQGmD 2xVvwNqMi8Rf5wuk5ntl460bR9lHJp18CTPmRZDb2UckkExxD1E6MVUxOjHNbHsi+M8QwbMZ 22EJH6fS75L/gkQ34P6eLbKnSvpaVBvnU1p9XFjxxltezYMDDG8tTYw1TJDgDVbsEUTRb4az oghJPfRI5pf3dzcmxYAWDmorh7w8jJKoed2kWcICd/puxg9ZG7dnxYR5bXfnpoaQD/n1MoZr +BJd86iwNc7QZ/7QT5qqdm1tQKJDRuCH2uMa7/5Nt3tVwalTaQqYELwMnrLCrVeHPcqj2WxB SfNx3k07xZsuBoAT8uw/xOTceRcC4mwrhPxYEGoWzmKbHcxMYOrAAmtyaJF23iGox2nAvCSY zs+/ALzOOpsG6qEFi4awCpri4paqRSFgOhKPUBIZeEHGtTZ0bLbSGbmjwJlJ2aAAe3Nbzaa4 ZQEpUGiZFdArBKA/gtLNUN+i+uL7+T3bwi8JeQ1oP+f0p73w3ekzhBqROWNn49wLOazQ02V3 VZ20S6o0OLV0nTv0yWvumajaubkMtqR3k/05EiuLILgbPtv1Cb/+t++naARfe4Van3o0JLtH +JyzvZ5WJLPyThGXKCGlduE2qcrDHhk30WQHfGV5jn/6HyyjgIHl/Ajng4cU7ti7qEE8629q rMjBqNPM56ZSlTrb7eAFUTUgvnXrp2dQ9279NZmvdxwNyI4tNhv9AxcP9Ad+KifxqJpqnJLP ZfsNMjLH+DpVmAptCtkT2hp3cY/UGf6khSVtqZMS60moYtNines2W2YEKOH2lQ+RKuziEIWc 12RLgfK/HLAisfULMdZlb76lAOC7vxtezjBrv561n6fZkDpotoo5CJbR9ovw88GUfXPD89O5 5omLSYjMgUS1/QOdjGGjnmM8Ontdf/uztiPq5TnmZhmvWkBt1XEmrTrgtHdHhbi6hD1jOUdR bSLwYJQ3036D18Ee9pbnvo9GUQcCjA4bgI2a01/+De1xlPWW59flVsVBrLe674+gNPuuyIsq 26Cg958iaRqr3qHzneCOABt/RKEtXzY+dZpx1AvcI1NRUgdfKpfpz4kaTrClFF2yAbzhfpf3 WDA+vTX7++lMxYKmS9sH9XR6VkOymnb3wuXTGHOiSanoyTeoWIWzYVwYDIPLp4d7MZGt25Yo 81VUuBfjPQcA8OWDxIh64Siok+BQ1NnhkBSPXfG60nJ6t0KrafOr4WGbYyfWzWkd7oSiw/sL i1PbGsxyKBG9kXunFUTyVtMvz1ShiegDFj8LoZXW6lCeUvAdRrWYf6ryeBvi7CHs9PnZoKza bjPSrhOMNnl3JNd4fbURSI1vvQk/Tsyw4Z8p+Mi2vGOlLpC7WYIWK5YIZSTUEQBk1Re4vKPR rpAppNSVVeJ2Esvl2cAhGj8pK95WjPyFvcACAAEzie4bMip/O4UJ2Vk+AzIMY4oKrfRB5ZFR gpbNw/xWJjhGAMqiTmWWdfHvP7efgNypdeBoLLLrdSe4ug8VwPZI8H38h20B8M0CvTQpklly jnys+0eYyNEmPyJb7sF4AT8l95ucH36dhTES6aT8MqElNcluOnQR0sZU9m1/kjsN61QTvuK8 1lPR0+yTlmzY8jJIeXV7d2Qc/MzdzWko7A0ucUEJZ8nxbfXv12qg+5p6/wLDz5mNPGNHYmwz PpqkGFW8QXrT9LwYi5v0RzmRuokepSTzd185fa4u4hYI41SzLnsvmGPVZ/L6zE+sSz0dg5zD u14ojCI9cNtuBRFzKuy2vOzjGwL9wULDnJE+tRES+if4VKBCHfqjQZdd596cprGLaaMpH4je PDEn9BigI1mEzedK3tLGUJrK059S2OHVhEgSvO5+igYLGgKC0BXUcdDXUm5yf0ZsV5CEGmXz r572UEoI+kpNtgS+zjzlYfTk0qkgeI7rrdxfOvw/wWkvcKd+p4DnW4GBAKOifU2R87NQM+yv pMwNIYSdJ6krMuVdu9PHbVQxlB35BPF5mV32xfFkAeYHbgrTzLC0Rnq+A2uTKZvaLIQcW/h1 X26qyG36YRIMu5ttddfTH1fl/S3XEzHckyMa2cYb4Wb7U4AAQuDq9IhYOajp5uMjGhEi7wJ+ YPDJxFzNfOVGx+WDTJqlfO6GtLPGn5WQFhORTLzEGIFfjMg3GcGanV4XqHR+DnctK+RjgBXC zRLVZnbfQ9IsJ/KY51kMmgyxlcXKdIgd44m4nOLgMyvVxwVnJFh2kmMNjcwFUa3Qj0m0cb43 Cg67kAKUwUwGZCaGMAHPPQuTqH3dvwN2oLnINOc6juwkmxISysLoCO75W1aw7UHGm6JuXA3F 60XtlsI4YTyUPUcIOKDy9hXQ0j+CJEBcdkUlB4giUnaC/WvM6n7Sdb45bMMPVsalwQx/dKF8 uGab/OmjQIBkscVJEMf7Vz4SlME3XvfUK8Aul/1Cu7irdZIMfrWSLwPNBEWyOen8Zw4fqwhJ xzKTafijkIE5jJ8iQjua+AKyoQpp3N6yL/R+N/3Ab0s7B+gsEbJ6M1BKoEBK43gca//gX/Pm qJQgsU1E1NIg2r68sbNwB9JuLo73xuSmgPXnI6XqcbOsCecWlS8WUluJVGf0B2fuXX4188ah UYAOLGNt1ls7JN5QkTXX+qFVn8RnZ894iO1qev7hje3MC+d+eLPYf+2E4P4hGhcMkfeQgDjt 4Aof9i7N0iZ2DHq0sw7WpzcBLusqAS7tXKCLxnp2cQH2y0QC1XxSfKeesSGuhEpwqOXnVas8 vs1XWZMlreuE3wZBMplhzBszlzqX0Lk5WnAAsMtnBy0hkc3CPr0Vny+SdJ1qAS+4rIHRrPyD KWx6RQcOgASRWH7ZdE5HxMyUOYPbwup5WipizCpmtg1tM/xulqEBTbtwiXkGhdOHDNsNgmmp PNNahtJONSUxP61EgZYuDzGFerMrYEbM63HbCjNmHPB4boDtGPKKRAGHtMq0alcGw5dAHCO2 6BEOeEKddZ07OImlTmeM0YzYBsF6+nEkAnSjIDbAfGoYZSpg5PH/M2+Ievb6Fbqz7K8GZxqD daSVExH/eAFMwZafqEYrl1DBejREbstWFDvSsGjn/ztwTgFeaEjgMwPEplFcADql9GjMUwYJ 5GGF2UU4Up1yee+11zev/6CFoKUPpFAxE9xJGWw9X0FHSOUfrlPp8UfRFYKntfHGLo5QDi/w F0p9pms6FGRNXS8u+G3+Wm4p79C8eQjZB05/42pVMdeVYyh4W2SFEvP1vPgSoXaWolG29VOd HwRommq3vywi98nUahndYns2mSVLEAn7cm+6oiUiuWLxKi8VePyhME3doScmnfQfxRhBF1Jy A0M+9OnwF5i2gciQjlggykTCEeZsqV1Ou11pzKTg7TQUH1bh4uLBZqu3cg/cewl/pGz/QAdi R+jlP+vm5O2MjFUfEtmRZOVaNwiFUhkzDTFW3BHe4KiRu9gCt1CMy4my1m89iGKjzFVa/7dO IwBvQktwrHmuhcv6MPcc7zuvuKzsqGwTVx650g8hNUM0oRTNMyTECzoSYoYFcsG7ZLlTS6GT A4xvljT5zxI69J9rYBTlWumSBBck2JureN7hXW0Jndvpq5W0F9XSejPFjjofNlq2OPuBhmBp bTdplt+sqyhGI8c6u9qbngQRnJgo0hVJgyYgnmE7+/zMqzv+CKa2eMYjN8HmHvyLuZvrIBex 1rHZruDwgXuPQaqSpR5DsgKXBCWzwQ8kT1V5fJZDwftGvLztNDp5HVNxFjyEGXR+/RsxLCdc kusXDyVufsHvX0f+Wio2ELkRt76sEAhI6EMt414EO3y0gQl5mpjG5JPr/it1CNHS4eq8IhZ8 mpTfj/eaKS9T9FijKZk7VCyxZRXfqonjC3Z+1oLO5tOJGPwyB3EeNaRsHSLXcePn9NufM+v0 +Jx+tGTvvloBUwCSUQVYpNX41YLGbhCknbEhoKC6p09Tgibbr5EtlH/dXedW1x9cAE+QSh8K TW4DHUxzS8BQN2qSg0hVaz1vVgowAc9Hi/0xrTSyl50so/u8kxClHQl0WWMy7Va7nnsxCRDI l+m2ciHz8T/IExCi8tA8mAhBQvuSnHPxNeixLHvaHiTzoOJkUhwxMk0nX3H+9nwAna0O24V7 WeiA3daqgy7JovCacxGdW2bAD3Qdm3OcteG9MMrM / show errors; delete from sys.duc$ where owner='SYS' and pack='DBMS_IJOB' and proc='DROP_USER_JOBS' and operation#=1 / insert into sys.duc$ (owner, pack, proc, operation#, seq, com) values ('SYS','DBMS_IJOB','DROP_USER_JOBS',1, 1, 'Drop all jobs with this LOG_USER, PRIV_USER or SCHEMA_USER') / commit /