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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

+ This is Oracle Database 12.1.0.2.

+ 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
027145B90
qcsprfro_tree()+113 CALL??? qcsprfro_tree() 000000005 000000005 0000007FD
000000A50
qcspafq()+286 CALL??? qcsprfro_tree() 027CDA340 027CDA340 000036CA8
000000000
qcspqbDescendents() CALL??? qcspafq() 027145FB0 027CDA900 0204708C8
+251 0204708C8
qcspqb()+223 CALL??? qcspqbDescendents() 020472B70 020472B40 027145FB0
143948997
kkmdrv()+94 CALL??? qcspqb() 020422838 000000000 027CDA300
000036C98
opiSem()+2532 CALL??? kkmdrv() 000000000 0135A2350 027146920
0135A3810

Cause

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