Re: TRIGGER:... created with compilation warnings ?... Basic Qs
Date: Tue, 29 Apr 2008 08:32:09 -0600
I had that exact symptom in a database a fellow DBA created with an RMAN clone. The problem ticket I received said the triggers had no bodies. When I tried to compile the trigger I got that symptom. The problem was when the DBA created the database, he forgot to add temp files to TEMP.
Added temp files, problem solved.Received on Tue Apr 29 2008 - 09:32:09 CDT