DBMS_KAFKA_PARTITIONS
DBMS_KAFKA_PARTITIONS describes partitions for Kafka topics associated with all Oracle SQL Access to Kafka (OSAK) views 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 OSAK view |
CLUSTER_ID |
VARCHAR2(40) |
NOT NULL |
ID of the OSAK cluster associated with the topic/partition |
APPLICATION_NAME |
VARCHAR2(30) |
NOT NULL |
Application name (also used as the Kafka group name) |
TOPIC_NAME |
VARCHAR2(249) |
NOT NULL |
Kafka topic name associated with the topic/partition |
PARTITION_ID |
NUMBER(38) |
NOT NULL |
Partition ID of the Kafka topic |
VIEW_ID |
NUMBER(38) |
NOT NULL |
ID of the OSAK view associated with the topic/partition |
VIEW_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the OSAK view associated with the topic/partition |
VIEW_SCHEMA |
VARCHAR2(128) |
NOT NULL |
Schema of the OSAK view associated with the topic/partition |
TEMP_TABLE_NAME |
VARCHAR2(128) |
Name of the OSAK global temporary table associated with the topic/partition The value of this column is null if the application type is |
|
TEMP_TABLE_SCHEMA |
VARCHAR2(128) |
Schema of the OSAK global temporary table associated with the topic/partition The value of this column is null if the application type is |
|
OPTIONS |
BLOB |
Options associated with the partition |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: