DBA_SUBSCR_REGISTRATIONS

DBA_SUBSCR_REGISTRATIONS displays information about all subscription registrations in the database.

Related View

USER_SUBSCR_REGISTRATIONS displays information about the subscription registrations owned by the current user.

Column

Datatype

NULL

Description

REG_ID

NUMBER

Registration ID

SUBSCRIPTION_NAME

VARCHAR2(128)

NOT NULL

Name of the subscription registration. The subscription name is of the form schema.queue if the registration is for a single consumer queue or schema.queue:consumer_name if the registration is for a multi-consumer queue.

LOCATION_NAME

VARCHAR2(256)

NOT NULL

Location endpoint of the registration

USER#

NUMBER

NOT NULL

Internally generated user ID

USER_CONTEXT

RAW(128)

Context the user provided during registration of PL/SQL registrations or an internally generated context for OCI registrations