DBMS_KAFKA_APPLICATIONS
DBMS_KAFKA_APPLICATIONS describes all Oracle SQL Access to Kafka (OSAK) applications in the database.
The role OSAK_ADMIN_ROLE allows users with no administrative privileges to query this table.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the application |
CLUSTER_ID |
VARCHAR2(40) |
NOT NULL |
ID of the OSAK cluster associated with the application |
APPLICATION_NAME |
VARCHAR2(30) |
NOT NULL |
Application name (also used as the Kafka group name) |
TOPIC_NAME |
VARCHAR2(249) |
NOT NULL |
Name of the Kafka topic associated with the application |
NUM_VIEWS |
NUMBER(38) |
NOT NULL |
Number of OSAK views for the application |
NUM_PARTITIONS |
NUMBER(38) |
NOT NULL |
Number of Kafka partitions associated with the OSAK views for the application |
NUM_VIEWS_REQUESTED |
NUMBER(38) |
NOT NULL |
Number of OSAK views requested for the application |
APPLICATION_TYPE |
VARCHAR2(30) |
NOT NULL |
Type of application:
|
OPTIONS |
BLOB |
NOT NULL |
User-supplied options (excluding AVRO-related schemas) |
AVRO_SCHEMA |
BLOB |
User-supplied AVRO schema for the Kafka topic value data | |
KEY_AVRO_SCHEMA |
BLOB |
Reserved for future use | |
EXT_TABLE_NAME |
VARCHAR2(128) |
Name of the external table created for the application | |
EXT_TABLE_SCHEMA |
VARCHAR2(128) |
Schema of the external table created for the application | |
PARTITION_TABLE_NAME |
VARCHAR2(128) |
Name of the PARTITIONS table created for the application |
|
PARTITION_TABLE_SCHEMA |
VARCHAR2(128) |
Schema of the PARTITIONS table created for the application |
|
PARTITION_VIEW_NAME |
VARCHAR2(128) |
Name of the PARTITIONS view created for the application |
|
PARTITION_VIEW_SCHEMA |
VARCHAR2(128) |
Schema of the PARTITIONS view created for the application |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: