Oracle Jserver

I got a full dump file from my client and I import this dump into my database. I noticed that they had Jserver on their database so that I have two unused schema on mine when I did the full import. The name of these two schemas are AURORA$JIS$UTILITY$,OSE$HTTP$ADMIN. Since I don't use Jserver, I guess I can drop these two schemas, but I want to confirm with you guys first. Secondly, let's assume, I did have Jserver before and I want to take Jserver out of my database, is there any scripts from Oracle I can run????

For your second question, you can run

$ORACLE_HOME/rdbms/admin/rmjvm.sql which will remove all the java objects period.

Sam

SAM,

thanks for your reply but the script is for prior to 8i

Metalink Note:209870.1
Subject: How to Reload the JVM in 9.2.0.X

Code:

---


    -- Start of File full_rmjvm.sql
    spool full_rmjvm.log
    set echo on
    connect / as sysdba
    startup mount
    alter system set "_system_trig_enabled" = fals scope=memory;
    alter system enable restricted session;
    alter database open;
    show parameters _system
    @?/rdbms/admin/rmaqjms.sql
    @?/rdbms/admin/rmcdc.sql
    @?/xdk/admin/rmxml.sql
    @?/javavm/install/rmjvm.sql
    truncate table java$jvm$status;
    select * from obj$ where obj#=0 and type#=0;
    delete from obj$ where obj#=0 and type#=0;
    commit;
    select owner, count(*) from all_objects
        where object_type like '%JAVA%' group by owner;
    select obj#, name from obj$
        where type#=28 or type#=29 or type#=30 or namespace=32;
    select o1.name from obj$ o1,obj$ o2
        where o1.type#=5 and o1.owner#=1 and o1.name=o2.name and  o2.type#=29;
    shutdown immediate
    set echo off
    spool off
    exit

---

Sam