While migrating a table from one Oracle instance to another, a trigger wound up in the wrong schema. No sweat, copy trigger code, drop trigger, create or repace in correct schema. No go, object with same name exists. Hunt for it, and the only place it seems to exist is in DBA_OBJECTS. Ther it has an object type of NEXT OBJECT. Hoe do I get rid of the &*(^ thing?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.