DBA_DDL_REGS

DBA_DDL_REGS displays all DDL notification registrations in the database.

USER_DDL_REGS displays DDL notification registrations that apply to tables owned by the current user. This view does not display the USERNAME column.

Column Datatype NULL Description
USERNAME VARCHAR2(128) NOT NULL Registration owner
REG_ID NUMBER NOT NULL Internal registration ID
TYPE VARCHAR2(8)  

Registration type. Possible values:

  • TABLE
  • SCHEMA
  • DATABASE
NAME VARCHAR2(257)   Name of the registered table, schema, or database
CLIENT_ID VARCHAR2(64)   User-specified client ID
INCLUDE_TRUNCATE VARCHAR2(3)   Indicates whether notifications are generated for TRUNCATE operations (YES) or not (NO)
INCLUDE_PMOP VARCHAR2(3)   Indicates whether notifications are generated for partition maintenance operations (YES) or not (NO)

Note: This view is available starting with Oracle AI Database 26ai.

See Also: “USER_DDL_REGS”