SYS.RMJVM dependencies on OBJAUTH$

Line 237: dbms_output.put_line('delete from objauth$');

233: end loop;
234:
235: initjvmaux.rollbackset;
236:
237: dbms_output.put_line('delete from objauth$');
238:
239: select count(*) into total_to_delete from objauth$
240: where obj# in (select obj# from java$rmjvm$aux);
241: commit;

Line 239: select count(*) into total_to_delete from objauth$

235: initjvmaux.rollbackset;
236:
237: dbms_output.put_line('delete from objauth$');
238:
239: select count(*) into total_to_delete from objauth$
240: where obj# in (select obj# from java$rmjvm$aux);
241: commit;
242: loop
243: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));

Line 245: delete from objauth$ where obj# in (select obj# from java$rmjvm$aux)

241: commit;
242: loop
243: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
244: initjvmaux.rollbackset;
245: delete from objauth$ where obj# in (select obj# from java$rmjvm$aux)
246: and rownum <= deletions_per_iteration;
247: commit;
248: exit when total_to_delete <= deletions_per_iteration;
249: total_to_delete := total_to_delete - deletions_per_iteration;

Line 365: -- syn$, objauth$, javaobj$, access$ and dependency$ using this script.

361: --
362: -- only delete from obj$ if all the java information was deleted
363: -- from the other tables correctly. Once we run this delete
364: -- there is no going back to remove the information from
365: -- syn$, objauth$, javaobj$, access$ and dependency$ using this script.
366: --
367: DECLARE
368: c1 number;
369: c2 number;

Line 394: select count(*) into c3 from objauth$ where obj# in

390: type#=28 or type#=29 or type#=30 or type#=56);
391: c4 := 0;
392: end if;
393:
394: select count(*) into c3 from objauth$ where obj# in
395: (select obj# from java$rmjvm$aux);
396: select count(*) into c6 from javaobj$ where obj# in
397: (select obj# from java$rmjvm$aux);
398: select count(*) into c5 from access$ where d_obj# in