DBA_KAFKA_PARTITIONS

DBA_KAFKA_PARTITIONS describes partitions for Kafka topics associated with all Oracle SQL Access to Kafka (OSAK) views in the database.

USER_KAFKA_PARTITIONS describes partitions for Kafka topics associated with OSAK views owned by the current user. This view does not display the OWNER or CLUSTER_ID columns.

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
CLUSTER_NAME VARCHAR2(30) NOT NULL User-supplied name of the associated Kafka server/cluster
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
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 LOAD, that is, if the application was created using the DBMS_KAFKA.CREATE_LOAD_APP procedure. The application type is displayed in the APPLICATION_TYPE column of the DBA_KAFKA_APPLICATIONS view.

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

See Also: