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. -- //www.freelists.org/webpage/oracle-l