-- Current user error log SELECT * FROM SYS.USER_ERRORS; -- Current user error log related with trigger SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='TRIGGER'; -- Current user error log related with procedure SELECT * FROM SYS.USER_ERRORS WHERE TYPE ='PROCEDURE'; -- All user error log SELECT * FROM SYS.DBA_ERRORS; -- All user error log related with trigger SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='TRIGGER'; -- All user error log related with procedure SELECT * FROM SYS.DBA_ERRORS WHERE TYPE ='PROCEDURE';
Wednesday, 8 March 2017
[Oracle] How to show trigger or procedure error log (트리거 또는 프로시져 에러 로그 확인 방법)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment