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"}}]