My Oracle Support Banner

12c OEM Not Showing Right Trigger Information , even when generating DDL (Doc ID 1592408.1)

Last updated on SEPTEMBER 16, 2018

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


WHEN clause in the trigger DDL is not visible from OEM 12c using "Edit" or "Generate DDL" options:-

Viewing the trigger shows not all relevant information.


When try to edit the trigger , the WHEN clause is not visible.

Generating DDL from OEM does not help either.


3rd party application or usage of command line showing the right trigger DDL.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.