Skip to main content

resource_pool_members

Creates, updates, deletes, gets or lists a resource_pool_members resource.

Overview​

Nameresource_pool_members
TypeResource
Idoci.database.resource_pool_members

Fields​

The following fields are returned by SELECT queries:

A list of Autonomous AI Database resource pool member OCIDs was retrieved for the specified Autonomous AI Database leader.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous AI Database.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectautonomousDatabaseId, regionopc-request-id, limit, pageLists the OCIDs of the Autonomous AI Database resource pool members for the specified Autonomous AI Database leader.<br />

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
autonomousDatabaseIdstringThe database [OCID](/Content/General/Concepts/identifiers.htm).
regionstringOCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
limitintegerThe maximum number of items to return per page.
opc-request-idstringUnique identifier for the request.
pagestringThe pagination token to continue listing from.

SELECT examples​

Lists the OCIDs of the Autonomous AI Database resource pool members for the specified Autonomous AI Database leader.<br />

SELECT
id
FROM oci.database.resource_pool_members
WHERE autonomousDatabaseId = '{{ autonomousDatabaseId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;