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)

XML

Notifications

You may request notification for Jade's weblog.

Syndication Feed

XML

Recent Comments

  1. Jade Rubick: And... yes and no
  2. Jade Rubick: Using hoptoad
  3. Jade Rubick: Much better
  4. Bodo Tasche: Link changed :)
  5. Bodo Tasche: Better commt emails. Now with color :)
  6. Jade Rubick: Filed a ticket
  7. Vinod Kurup: Wow
  8. Jade Rubick: Then what
  9. Paul Post: Percentages
  10. Paul Post: I might be an ENFJ?