Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API. Depending on the database version and configuration, ORDS database APIs provide services such as manage pluggable databases, export data, and review database performance.
To install and configure Oracle REST Data Services refer to the Oracle® REST Data Services Installation and Configuration Guide.
An OpenAPI V3 document that describes the available ORDS database API services can be retrieved from a running ORDS instance. The API document can be imported into compatible development tools and invoked from there. The URL to retrieve the API document depends on the your configuration.
The pattern for the API document URL is:
https://<server>/<context root>/<my database>/<my schema>/_/db-api/stable/<service path>
Where, the <my database> and <my schema> variables can be optional, depending on the ORDS configuration and the service invoked.'
version: 2026.03.26
title: Oracle REST Data Services Oracle Transactional Event Queues API
contact:
name: Oracle REST Data Services
url: https://www.oracle.com/database/technologies/appdev/rest.html
x-summary: Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.
tags:
- name: Oracle Transactional Event Queues
description: Services related to Oracle Transactional Event Queues.
paths:
/database/txeventq/topics:
get:
tags:
- Oracle Transactional Event Queues
summary: Get all Transactional Event Queue Topics in the schema
description: This API is compiant witht the Confluent Kafka API. Get a list of Transactional Event Queue Topics defined. A client requires SQL Developer role to invoke this service. Database user requires EXECUTE on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: List of Transactional Event Queue Topics.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
x-internal-id: database-txeventq-topics-get
x-filename-id: database-txeventq-topics-get
/database/txeventq/topics/{topic_name}:
post:
tags:
- Oracle Transactional Event Queues
summary: Produce a message to the Transactional Event Queue Topic specified by topic_name
description: Produce a message to the topic specified by topic_name with a key and value. Optionally, specify a partition to produce the message in. If no partition is specified one is automatically chosen. A client requires SQL Developer role to invoke this service. Database user requires Execute privilege on DBMS_AQ, DBMS_AQADM and OWA_UTIL packages. Topic must belong to Database User's schema.
responses:
'201':
description: The successfully created record.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Produce Messages in Topic:
summary: This API produces messages in Topic
value:
records:
- key: color
value: red
partition: 5
- key: 7
value: 77
parameters:
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-post
x-filename-id: database-txeventq-topics-topic_name-post
get:
tags:
- Oracle Transactional Event Queues
summary: Get description of a particular Transactional Event Queue Topic.
description: Get description of a particular topic. A client requires SQL Developer role to invoke this service. Database user requires READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: Topic Description
parameters:
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-get
x-filename-id: database-txeventq-topics-topic_name-get
/database/txeventq/clusters/{cluster_id}/consumer-groups:
get:
tags:
- Oracle Transactional Event Queues
summary: Get Consumer Groups in Cluster
description: Returns the list of consumer groups that belong to the specified cluster. A client requires SQL Developer role to invoke this service.
responses:
'200':
description: Consmer Group Description
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-get
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-get
/database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}:
post:
tags:
- Oracle Transactional Event Queues
summary: Create a Consumer Group
description: Create a new consumer consumer group in the specified Cluster Id. A client requires SQL Developer role to invoke this service. Database user requires Execute privilege on DBMS_AQADM and OWA_UTIL packages and the Topic must be created in the Database User's' schema.
responses:
'201':
description: Successfully created Consumer Group.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Create a Consumer Group:
summary: This API creates a Consumer Group in Topic
value:
topic_name: myTopic
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
- name: Topic
in: header
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-post
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-post
get:
tags:
- Oracle Transactional Event Queues
summary: Get a Consumer Group
description: Get the consumer group specified by the consumer_group_id.
responses:
'200':
description: The Consumer Group
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-get
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-get
delete:
tags:
- Oracle Transactional Event Queues
summary: Delete a Consumer Group
description: Delete consumer consumer group in the specified Cluster Id. A client requires SQL Developer role to invoke this service. Database User requires Execute privilege on DBMS_AQADM and OWA_UTIL packages and the Topic must have been created in Database User's schema.
responses:
'200':
description: Deleted Consumer Group.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Delete a Consumer Group:
summary: This API deletes a Consumer Group in Topic
value:
topic_name: myTopic
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
- name: Topic
in: header
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-delete
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-delete
/database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lag-summary:
get:
tags:
- Oracle Transactional Event Queues
summary: Get lag summary for Consumer Groups in Cluster
description: Gets the max and total lag of the consumers in the specified consumer group. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: The Consumer Group Lag Summary.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-lag-summary-get
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-lag-summary-get
/database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lags:
get:
tags:
- Oracle Transactional Event Queues
summary: 'Lags/Offsets of consumers in the Consumer group '
description: Gets a list of Current/Log-End Offsets and Lag of consumers belonging to the specified consumer group. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: The Consumer Lag and Offsets
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-lags-get
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-lags-get
/database/txeventq/clusters/{cluster_id}/topics:
post:
tags:
- Oracle Transactional Event Queues
summary: Create a new Transactional Event Queue Topic
description: Create a new Topic. A client requires SQL Developer role to invoke this service. Database User requires Execute privilege on DBMS_AQADM and OWA_UTIL packages as well as Resource and Unlimited Tablespace privileges.
responses:
'201':
description: The successfully created topic.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Create a Topic:
summary: This API creates a Topic
value:
topic_name: myTopic
partitions_count: '10'
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: topic_name
in: header
required: true
schema:
type: string
- name: partitions_count
in: header
required: true
schema:
type: integer
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-post
x-filename-id: database-txeventq-clusters-cluster_id-topics-post
get:
tags:
- Oracle Transactional Event Queues
summary: List Transactional Event Queue Topics that belong to the specified database cluster
description: List topics that belong to the specified database cluster. A client requires SQL Developer role to invoke this service. Database User requires Execute privilege on DBMS_AQADM and OWA_UTIL packages and READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: Topics in Cluster
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-get
x-filename-id: database-txeventq-clusters-cluster_id-topics-get
/database/txeventq/clusters/{cluster_id}/topics/{topic_name}:
delete:
tags:
- Oracle Transactional Event Queues
summary: Delete the Transactional Event Queue Topic with the specified topic_name
description: Delete the topic with the specified topic_name. A client requires SQL Developer role to invoke this service. Database User requires Execute privilege on DBMS_AQADM and OWA_UTIL packages and the Topic must have been created in the database user's schema.
responses:
'200':
description: Deleted topic.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-{topic_name}-delete
x-filename-id: database-txeventq-clusters-cluster_id-topics-topic_name-delete
get:
tags:
- Oracle Transactional Event Queues
summary: Describes Transactional Event Queue Topic in Cluster
description: Get a full description of the topic specified by the topic_name. A client requires SQL Developer role to invoke this service. Database User requires to have READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: The topic specified.
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-{topic_name}-get
x-filename-id: database-txeventq-clusters-cluster_id-topics-topic_name-get
/database/txeventq/clusters/{cluster_id}/topics/{topic_name}/partitions:
get:
tags:
- Oracle Transactional Event Queues
summary: List Partitions for a Transactional Event Queue Topic in Cluster
description: Get all the partitions that belong to a specified topic. A client requires SQL Developer role to invoke this service. Database User requires READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: The topic partitions.
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-{topic_name}-partitions-get
x-filename-id: database-txeventq-clusters-cluster_id-topics-topic_name-partitions-get
/database/txeventq/clusters/{cluster_id}/topics/{topic_name}/partitions/{partition_id}:
get:
tags:
- Oracle Transactional Event Queues
summary: Describe Transactional Event Queue Topic Partition specified in Cluster
description: Get the partition with a specified partition_id for the specified Topic in cluster. A client requires SQL Developer role to invoke this service. Database User requires READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: The specified Topic Partition
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: partition_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-topics-{topic_name}-partitions-{partition_id}-get
x-filename-id: database-txeventq-clusters-cluster_id-topics-topic_name-partitions-partition_id-get
/database/txeventq/consumers/{group_name}:
post:
tags:
- Oracle Transactional Event Queues
summary: Create Consumer Instance
description: Create a new consumer instance in the consumer group. Database user requires SQL Developer role and EXECUTE privilege on OWA_UTIL package to invoke this service. The database user also requires SELECT privilege on V_$SESSION to perform this operation.
responses:
'201':
description: Created consumer instance
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Create Consumer Instance:
summary: This create a Consumer Instance in a Consumer Group
value:
name: MY-Consumer-Instance
parameters:
- name: group_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-post
x-filename-id: database-txeventq-consumers-group_name-post
/database/txeventq/consumers/{group_name}/instances/{instance}:
delete:
tags:
- Oracle Transactional Event Queues
summary: Delete Consumer Instance
description: Delete the consumer instance. A client requires SQL Developer role to invoke this service. Also EXECUTE privilege on OWA_UTIL package.
responses:
'204':
description: Deleted Consumer Instance.
'404':
description: Not Found.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-delete
x-filename-id: database-txeventq-consumers-group_name-instances-instance-delete
/database/txeventq/clusters/{cluster_id}/consumer-groups/{consumer_group_id}/lags/{topic_name}/partitions/{partition_id}:
get:
tags:
- Oracle Transactional Event Queues
summary: Get consumer lag for Transactional Event Queue Topic Partition
description: Get the consumer lag on a specified partition in a topic. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: Consumer-Group lag for Partition
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: cluster_id
in: path
required: true
schema:
type: string
- name: consumer_group_id
in: path
required: true
schema:
type: string
- name: partition_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-clusters-{cluster_id}-consumer-groups-{consumer_group_id}-lags-{topic_name}-partitions-{partition_id}-get
x-filename-id: database-txeventq-clusters-cluster_id-consumer-groups-consumer_group_id-lags-topic_name-partitions-partition_id-get
/database/txeventq/consumers/{group_name}/instances/{instance}/offsets:
get:
tags:
- Oracle Transactional Event Queues
summary: Get Consumer last Commit Offsets
description: Get the last committed offsets for the given partition. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: Consumer-Group Commit Offsets
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Consumer-Group Commit Offsets:
summary: Get Consumer's Commit Offsets
value:
partitions:
- topic: myTopic1
partition: 0
- topic: myTopic2
partition: 3
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
- name: List of Topic and Partition
in: query
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-offsets-get
x-filename-id: database-txeventq-consumers-group_name-instances-instance-offsets-get
/database/txeventq/consumers/{group_name}/instances/{instance}/positions:
post:
tags:
- Oracle Transactional Event Queues
summary: Seek to specified Transactional Event Queue Topic partition offsets for Consumer Group
description: Seek to the offsets for each of the Topic partition. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQ, DBMS_AQADM and OWA_UTIL packages. Also needs READ privilege on V$DATABASE and V$TRANSPORTABLE_PLATFORM.
responses:
'201':
description: Moved Consumer offset to specified position
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Move Consumer Offset:
summary: Move Consumer position to specified offset in Partition
value:
offsets:
- topic: myTopic
partition: 0
offset: 2
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-positions-post
x-filename-id: database-txeventq-consumers-group_name-instances-instance-positions-post
/database/txeventq/consumers/{group_name}/instances/{instance}/positions/beginning:
post:
tags:
- Oracle Transactional Event Queues
summary: Seek to start of Partitions for Consumer Group
description: Seek to the beginning offset for each of the given partitions. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQ and OWA_UTIL packages.
responses:
'201':
description: Moved Consumer offset to start of the Partitions specified.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Move Consumer Offset to the Start of Partition:
summary: Move Consumer position to the start of specified Partitions
value:
partitions:
- topic: myTopic
partition: 4
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-positions-beginning-post
x-filename-id: database-txeventq-consumers-group_name-instances-instance-positions-beginning-post
/database/txeventq/consumers/{group_name}/instances/{instance}/positions/end:
post:
tags:
- Oracle Transactional Event Queues
summary: Seek to End of Partitions for Consumer Group
description: Seek to the End offset for each of the given partitions. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQ and OWA_UTIL packages.
responses:
'201':
description: 'Moved Consumer offset to end of the Partitions specified '
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Move Consumer Offset to the end of Partition:
summary: Move Consumer position to the end of specified Partitions
value:
partitions:
- topic: myTopic
partition: 4
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-positions-end-post
x-filename-id: database-txeventq-consumers-group_name-instances-instance-positions-end-post
/database/txeventq/consumers/{group_name}/instances/{instance}/records:
get:
tags:
- Oracle Transactional Event Queues
summary: Fetch messages for the specified Consumer
description: Fetch messages for the specified Consumer in Consumer Group from Topics its Subscribed to. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQ, DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: The fetched messages
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
- name: Maximum Bytes of Records
in: query
required: false
schema:
type: integer
- name: Timeout in Milli Seconds
in: query
required: false
schema:
type: integer
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-records-get
x-filename-id: database-txeventq-consumers-group_name-instances-instance-records-get
/database/txeventq/consumers/{group_name}/instances/{instance}/subscription:
get:
tags:
- Oracle Transactional Event Queues
summary: Subscribed list of Transactional Event Queue Topics
description: Get the current subscribed list of topics for the consumer group instance. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packagse.
responses:
'200':
description: The queried record.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: group_name
in: path
required: true
schema:
type: string
- name: instance
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-consumers-{group_name}-instances-{instance}-subscription-get
x-filename-id: database-txeventq-consumers-group_name-instances-instance-subscription-get
/database/txeventq/topics/{topic_name}/partitions:
get:
tags:
- Oracle Transactional Event Queues
summary: Describe Transactional Event Queue Topic Partitions
description: Get a list of partitions for the specified topic_name. A client requires SQL Developer role to invoke this service. Database User requires READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: The queried record.
parameters:
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-partitions-get
x-filename-id: database-txeventq-topics-topic_name-partitions-get
/database/txeventq/topics/{topic_name}/partitions/{partition_id}:
post:
tags:
- Oracle Transactional Event Queues
summary: Produce messages in the specified Transactional Event Queue Topic Partition
description: Produce messages to the specified partition of the topic. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQ, DBMS_AQADM and OWA_UTIL packages.
responses:
'201':
description: Produced messages to the specified partition of the topic
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
examples:
Produce Messages to a specified Partition:
summary: Produce messages in the specified Partitions
value:
records:
- key: 99
value: 9999
parameters:
- name: partition_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-partitions-{partition_id}-post
x-filename-id: database-txeventq-topics-topic_name-partitions-partition_id-post
get:
tags:
- Oracle Transactional Event Queues
summary: Describe the specified Transactional Event Queue Topic Partition
description: Get metadata details of a specified partition in the topic. A client requires SQL Developer role to invoke this service. Database User requires READ privilege on USER_QUEUE_SHARDS.
responses:
'200':
description: The Topic Partition Metadata.
parameters:
- name: partition_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-partitions-{partition_id}-get
x-filename-id: database-txeventq-topics-topic_name-partitions-partition_id-get
/database/txeventq/topics/{topic_name}/partitions/{partition_id}/offsets:
get:
tags:
- Oracle Transactional Event Queues
summary: Get Transactional Event Queue Topic Partition Offsets
description: Get the first and last offset in the specified partition. A client requires SQL Developer role to invoke this service. Database User requires EXECUTE privilege on DBMS_AQADM and OWA_UTIL packages.
responses:
'200':
description: The Topic Partition Offsets.
'400':
description: Bad Request.
content:
application/json:
schema:
type: object
properties:
SQL ERROR MESSAGE:
type: string
parameters:
- name: partition_id
in: path
required: true
schema:
type: string
- name: topic_name
in: path
required: true
schema:
type: string
x-internal-id: database-txeventq-topics-{topic_name}-partitions-{partition_id}-offsets-get
x-filename-id: database-txeventq-topics-topic_name-partitions-partition_id-offsets-get
components:
securitySchemes:
BasicAuth:
type: http
scheme: basic
BearerAuth:
type: http
scheme: bearer
OAuth2:
type: oauth2
flows:
implicit:
authorizationUrl: /oauth/auth
scopes: {}
authorizationCode:
authorizationUrl: /oauth/auth
tokenUrl: /oauth/token
scopes: {}
clientCredentials:
tokenUrl: /oauth/token
scopes: {}
externalDocs:
description: Oracle REST Data Services product documentation.
url: https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/