5.308 DBA_DDL_REGS

DBA_DDL_REGS displays all DDL notification registrations in the database.

Related View

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 Database 23ai.

See Also:

"USER_DDL_REGS"