SYS.RMJVM dependencies on DEPENDENCY$

Line 177: dbms_output.put_line('delete from dependency$');

173: begin
174:
175: initjvmaux.rollbackset;
176:
177: dbms_output.put_line('delete from dependency$');
178:
179: if remove_all then
180: select count(*) into total_to_delete from dependency$
181: where p_obj# in (select obj# from java$rmjvm$aux);

Line 180: select count(*) into total_to_delete from dependency$

176:
177: dbms_output.put_line('delete from dependency$');
178:
179: if remove_all then
180: select count(*) into total_to_delete from dependency$
181: where p_obj# in (select obj# from java$rmjvm$aux);
182: else
183: select count(*) into total_to_delete from dependency$
184: where p_obj# in (select obj# from obj$ where (type#=29 or type#=56));

Line 183: select count(*) into total_to_delete from dependency$

179: if remove_all then
180: select count(*) into total_to_delete from dependency$
181: where p_obj# in (select obj# from java$rmjvm$aux);
182: else
183: select count(*) into total_to_delete from dependency$
184: where p_obj# in (select obj# from obj$ where (type#=29 or type#=56));
185: end if;
186: commit;
187:

Line 192: delete from dependency$ where p_obj# in

188: loop
189: dbms_output.put_line(total_to_delete ||' remaining at ' || to_char(sysdate,'mm-dd hh:mi:ss'));
190: initjvmaux.rollbackset;
191: if remove_all then
192: delete from dependency$ where p_obj# in
193: (select obj# from java$rmjvm$aux)
194: and rownum <= deletions_per_iteration;
195: else
196: delete from dependency$ where p_obj# in

Line 196: delete from dependency$ where p_obj# in

192: delete from dependency$ where p_obj# in
193: (select obj# from java$rmjvm$aux)
194: and rownum <= deletions_per_iteration;
195: else
196: delete from dependency$ where p_obj# in
197: (select obj# from obj$ where (type#=29 or type#=56))
198: and rownum <= deletions_per_iteration;
199: end if;
200: commit;

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 380: select count(*) into c2 from dependency$ where p_obj# in

376: select count(*) into c1 from syn$ where obj# in
377: (select o1.obj# from obj$ o1,obj$ o2
378: where o1.name=o2.name and
379: o1.type#=5 and o1.owner#=1 and o2.type#=29);
380: select count(*) into c2 from dependency$ where p_obj# in
381: (select obj# from java$rmjvm$aux);
382: select count(*) into c4 from javasnm$;
383: else
384: select count(*) into c1 from syn$ where obj# in

Line 388: select count(*) into c2 from dependency$ where p_obj# in

384: select count(*) into c1 from syn$ where obj# in
385: (select o1.obj# from obj$ o1,obj$ o2,java$rmjvm$aux j
386: where o1.name=o2.name and o1.type#=5 and o1.owner#=1
387: and o2.obj#=j.obj#);
388: select count(*) into c2 from dependency$ where p_obj# in
389: (select obj# from obj$ where
390: type#=28 or type#=29 or type#=30 or type#=56);
391: c4 := 0;
392: end if;

Line 431: where obj# in (select p_obj# from dependency$);

427:
428: insert into java$rmjvm$aux
429: (select obj# from obj$ where type#=10 and owner#=1);
430: delete from java$rmjvm$aux
431: where obj# in (select p_obj# from dependency$);
432: delete from obj$ where obj# in (select obj# from java$rmjvm$aux);
433: commit;
434: delete from java$rmjvm$aux;
435: commit;