Yes - if you had run AUDIT PROCEDURE before creation. Or if you'd SET ECHO ON and saved the log file from the deployment from SQL*Plus or equivalent. On Tue, Apr 1, 2014 at 11:38 PM, Nik Tek <niktek2005@xxxxxxxxx> wrote: > Hi, > > Is there a way to find that a certain stored procedure was ever created in > Oracle? > When I deploy the schema from a file, I'm missing few SPs, I wanted to > know if the stored procedure was ever tried to deploy. > > > Thank you > Nik > -- Adam Musch ahmusch@xxxxxxxxx