ListPluggableDatabases
GET {{baseUrl}}/pluggableDatabases?compartmentId=<string>&databaseId=<string>&limit=10&page=<string>&sortBy=TIMECREATED&sortOrder=ASC&lifecycleState=<string>&pdbName=<string>
Gets a list of the pluggable databases in a database or compartment. You must provide either a databaseId or compartmentId value.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
compartmentId | string | The compartment OCID. | |
databaseId | string | The OCID of the database. | |
limit | number | The maximum number of items to return per page. | |
page | string | The pagination token to continue listing from. | |
sortBy | string | The field to sort by. You can provide one sort order (sortOrder). Default order for TIMECREATED is descending. Default order for PDBNAME is ascending. The PDBNAME sort order is case sensitive. | |
sortOrder | string | The sort order to use, either ascending (ASC) or descending (DESC). | |
lifecycleState | string | A filter to return only resources that match the given lifecycle state exactly. | |
pdbName | string | A filter to return only pluggable databases that match the entire name given. The match is not case sensitive. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string |
RESPONSES
status: OK
[{"id":"\u003cstring\u003e","lifecycleState":"TERMINATED","pdbName":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","containerDatabaseId":"\u003cstring\u003e","openMode":"MIGRATE","compartmentId":"\u003cstring\u003e","connectionStrings":{"allConnectionStrings":{"ad_1d8":"\u003cstring\u003e","ad__8":"\u003cstring\u003e","pariatur_f":"\u003cstring\u003e","ullamco9d":"\u003cstring\u003e"},"pdbDefault":"\u003cstring\u003e","pdbIpDefault":"\u003cstring\u003e"},"definedTags":{"sitae":{"cillum7bd":{},"Excepteur3":{},"aute5":{},"ullamco_a0":{}}},"freeformTags":{"fugiat_ea":"\u003cstring\u003e","amet_57":"\u003cstring\u003e"},"isRestricted":"\u003cboolean\u003e","lifecycleDetails":"\u003cstring\u003e","pdbNodeLevelDetails":[{"nodeName":"\u003cstring\u003e","openMode":"READ_WRITE"},{"nodeName":"\u003cstring\u003e","openMode":"MIGRATE"}],"refreshableCloneConfig":{"isRefreshableClone":"\u003cboolean\u003e"}},{"id":"\u003cstring\u003e","lifecycleState":"DISABLED","pdbName":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","containerDatabaseId":"\u003cstring\u003e","openMode":"MOUNTED","compartmentId":"\u003cstring\u003e","connectionStrings":{"allConnectionStrings":{"officia_ca6":"\u003cstring\u003e","consequat_eba":"\u003cstring\u003e"},"pdbDefault":"\u003cstring\u003e","pdbIpDefault":"\u003cstring\u003e"},"definedTags":{"ea_3d9":{"eaf":{}},"sit_3":{"occaecat52":{},"exercitation__4":{}}},"freeformTags":{"amet_e":"\u003cstring\u003e"},"isRestricted":"\u003cboolean\u003e","lifecycleDetails":"\u003cstring\u003e","pdbNodeLevelDetails":[{"nodeName":"\u003cstring\u003e","openMode":"READ_ONLY"},{"nodeName":"\u003cstring\u003e","openMode":"MIGRATE"}],"refreshableCloneConfig":{"isRefreshableClone":"\u003cboolean\u003e"}}]