I'm moving an Oracle instance from one multi database app to several one databse apps. Somehow, a couple of triggeres wound up in the wrong schema. No sweat, drop trigger yada, create or replace , so on and so forth. No go, object name in use. Try to find it, using several tools, no such object. Query dba_objects, there it is, with an OBJECT_TYPE of NEXT OBJECT. Que?
What the heck is a NEXT OBJECT and how do I get rid of it?