Database Administration (MOSC)

MOSC Banner

dropjava jar file issue - ORA-29537

edited Oct 6, 2017 12:28PM in Database Administration (MOSC) 1 commentAnswered ✓

I don't seem to have the jar file to drop this so I can't use dropjava command, any clean way to delete these?

I can't use dropjava here without getting "ORA-29537: class or resource cannot be created or dropped directly". I seem to have mismatch in source vs class. If I can't use dropjava, could one you use below sql statements to cleanup safely?

DROP JAVA SOURCE fa2_name;

And

DROP JAVA CLASS fa2_name;

select *

from user_objects

where object_type like '%JAVA%';

thank you

Edit: I have Oracle 11g RAC on Linux 6.7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center