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.<br>Hoe do I get rid of the &*(^ thing?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
'Invisable' trigger- how to drop?
- Thread starter LorneG
- Start date
Similar threads
