DBA Data[Home] [Help]

SYS.INITJVMAUX dependencies on OBJ$

Line 263: select sum(length) into free from idl_ub1$ u,obj$ o

259: if sys_context('USERENV', 'CON_ID') < 2 then
260: select sum(length) into free from idl_ub1$,x$joxft
261: where obj#=joxftobn and bitand(joxftflags,96)!=0;
262: tablespace_limit := tablespace_limit - free;
263: select sum(length) into free from idl_ub1$ u,obj$ o
264: where o.obj#=u.obj# and o.type#=56 and name like 'Locale%';
265: tablespace_limit := tablespace_limit - free;
266: select sum(bytes) into free from dba_free_space
267: where tablespace_name='SYSTEM';

Line 590: update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$

586:
587: -- drop sros during up/downgrade
588: procedure drop_sros as
589: begin
590: update obj$ set status=5 where obj#=(select obj# from obj$,javasnm$
591: where owner#=0 and type#=29 and short(+)=name and
592: nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
593: commit;
594: declare

Line 597: from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;

593: commit;
594: declare
595: cursor C1 is select
596: u.name, o.name
597: from obj$ o,user$ u where o.type#=56 and u.user#=o.owner#;
598: ddl_statement varchar2(200);
599: uname varchar2(30);
600: oname varchar2(30);
601: iterations number;

Line 609: select count(*) into iterations from obj$ where type#=56;

605: begin
606: previous_iterations := 10000000;
607: loop
608: -- To make sure we eventually stop, pick a max number of iterations
609: select count(*) into iterations from obj$ where type#=56;
610: exit when iterations=0 or iterations >= previous_iterations;
611: previous_iterations := iterations;
612: loop_count := 0;
613: open C1;

Line 638: update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$

634: end loop;
635: end;
636: commit;
637: drp('delete from java$policy$shared$table');
638: update obj$ set status=1 where obj#=(select obj# from obj$,javasnm$
639: where owner#=0 and type#=29 and short(+)=name and
640: nvl(longdbcs,name)='oracle/aurora/rdbms/Compiler');
641: commit;
642: end;