Not sure if this is what you're thinking of, but you can set an event to create dump files in user_dump_dest when a certain errors is raised, e.g. the following would work for any ORA-0942 (table or view does not exist) errors: event="942 trace name errorstack level 3" Regards, Brandon