dropjava jar file issue - ORA-29537
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