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>


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-l
Received on Tue Apr 29 2008 - 09:32:09 CDT

Original text of this message