I've been tinkering with writing a trigger to log my table creation and manipulation for later tracking and review.
The challenge is that my trigger logic is stored in the same schema on which I've put the trigger. Because of this, whenever I recompile the trigger or the package or whatever, the trigger itself fires. Also, if another component requires a recompile, the trigger fires.
The trigger has been failing and, in fact, locking my database session. I have started putting guards on the trigger to prevent this and haven't worked it out yet.
Perhaps someone on the site has experience or advice? Or just tell me to use AUDIT commands instead?