Drop User Gets Error ORA-00604/ORA-942 (Doc ID 2192171.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


+ This is Oracle Database

+ Dropping a user fails with ORA-604 and ORA-942 errors.

+ An event trace on the ORA-942 reveals the problem with a missing javajar$ table

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=ct0qvwfca6gz7) -----
select name from javajar$ where owner#=:1

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
qcsprfro()+867 CALL??? ksfpec() 01367A2C0 0135A22E8
1D21B33DD3808CB 7FEF7E0E7F5
qcsprfro_tree()+344 CALL??? qcsprfro() 000000000 000000000 000DA4D80
qcsprfro_tree()+113 CALL??? qcsprfro_tree() 000000005 000000005 0000007FD
qcspafq()+286 CALL??? qcsprfro_tree() 027CDA340 027CDA340 000036CA8
qcspqbDescendents() CALL??? qcspafq() 027145FB0 027CDA900 0204708C8
+251 0204708C8
qcspqb()+223 CALL??? qcspqbDescendents() 020472B70 020472B40 027145FB0
kkmdrv()+94 CALL??? qcspqb() 020422838 000000000 027CDA300
opiSem()+2532 CALL??? kkmdrv() 000000000 0135A2350 027146920


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms