Jump to

• Request
• Response

Seek to specified Transactional Event Queue Topic partition offsets for Consumer Group

post

/database/txeventq/consumers/{group_name}/instances/{instance}/positions

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.

Request

Path Parameters

• group_name(required): string
• instance(required): string

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

201 Response

Moved Consumer offset to specified position

400 Response

Bad Request.

Body ()

Root Schema : schema

Type: object

Show Source

• SQL ERROR MESSAGE: string

{
    "type":"object",
    "properties":{
        "SQL ERROR MESSAGE":{
            "type":"string"
        }
    }
}

Examples

Select an example Move Consumer position to specified offset in Partition

Back to Top