Blog‎ > ‎

Oracle "BIN" Invalid objects

posted Feb 11, 2009, 12:14 PM by Jade Rubick

The invalid objects that looked something like BIN* I believe represent binary forms of triggers or other pl/sql blocks. There must be a bug in Oracle which does not drop the binary forms when dropping the original object.

The solution I've used is:

sqlplus user/pass
purge recycle bin;

then recompile invalid objects

Courtesy of MB