DBMS_KAFKA_PARTITIONS

7.190 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 `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 `DBMS_KAFKA_APPLICATIONS` view.
`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 `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 `DBMS_KAFKA_APPLICATIONS` view.
`OPTIONS`	`BLOB`		Options associated with the partition

Note:

This view is available starting with Oracle Database 23ai.