Re: TRIGGER:... created with compilation warnings ?... Basic Qs
From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Tue, 29 Apr 2008 08:32:09 -0600
Message-Id: <1209479529.27969.17.camel@lidhfed.lidh.com>
Date: Tue, 29 Apr 2008 08:32:09 -0600
Message-Id: <1209479529.27969.17.camel@lidhfed.lidh.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 29 2008 - 09:32:09 CDT