Jade's weblog Archive

"BIN" Invalid objects

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

11:01 PM, 13 Feb 2006 by Jade Rubick Permalink | Comments (0)

Of course, the network card doesn't work out of the box..

06:19 PM, 08 Feb 2006 by Jade Rubick Permalink | Comments (0)

XML