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

KeyDatatypeRequiredDescription
compartmentIdstringThe compartment OCID.
databaseIdstringThe OCID of the database.
limitnumberThe maximum number of items to return per page.
pagestringThe pagination token to continue listing from.
sortBystringThe 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.
sortOrderstringThe sort order to use, either ascending (ASC) or descending (DESC).
lifecycleStatestringA filter to return only resources that match the given lifecycle state exactly.
pdbNamestringA filter to return only pluggable databases that match the entire name given. The match is not case sensitive.

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

[{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;TERMINATED&quot;,&quot;pdbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;containerDatabaseId&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;MIGRATE&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;connectionStrings&quot;:{&quot;allConnectionStrings&quot;:{&quot;ad_1d8&quot;:&quot;\u003cstring\u003e&quot;,&quot;ad__8&quot;:&quot;\u003cstring\u003e&quot;,&quot;pariatur_f&quot;:&quot;\u003cstring\u003e&quot;,&quot;ullamco9d&quot;:&quot;\u003cstring\u003e&quot;},&quot;pdbDefault&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbIpDefault&quot;:&quot;\u003cstring\u003e&quot;},&quot;definedTags&quot;:{&quot;sitae&quot;:{&quot;cillum7bd&quot;:{},&quot;Excepteur3&quot;:{},&quot;aute5&quot;:{},&quot;ullamco_a0&quot;:{}}},&quot;freeformTags&quot;:{&quot;fugiat_ea&quot;:&quot;\u003cstring\u003e&quot;,&quot;amet_57&quot;:&quot;\u003cstring\u003e&quot;},&quot;isRestricted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbNodeLevelDetails&quot;:[{&quot;nodeName&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;READ_WRITE&quot;},{&quot;nodeName&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;MIGRATE&quot;}],&quot;refreshableCloneConfig&quot;:{&quot;isRefreshableClone&quot;:&quot;\u003cboolean\u003e&quot;}},{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifecycleState&quot;:&quot;DISABLED&quot;,&quot;pdbName&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;containerDatabaseId&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;MOUNTED&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;connectionStrings&quot;:{&quot;allConnectionStrings&quot;:{&quot;officia_ca6&quot;:&quot;\u003cstring\u003e&quot;,&quot;consequat_eba&quot;:&quot;\u003cstring\u003e&quot;},&quot;pdbDefault&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbIpDefault&quot;:&quot;\u003cstring\u003e&quot;},&quot;definedTags&quot;:{&quot;ea_3d9&quot;:{&quot;eaf&quot;:{}},&quot;sit_3&quot;:{&quot;occaecat52&quot;:{},&quot;exercitation__4&quot;:{}}},&quot;freeformTags&quot;:{&quot;amet_e&quot;:&quot;\u003cstring\u003e&quot;},&quot;isRestricted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;lifecycleDetails&quot;:&quot;\u003cstring\u003e&quot;,&quot;pdbNodeLevelDetails&quot;:[{&quot;nodeName&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;READ_ONLY&quot;},{&quot;nodeName&quot;:&quot;\u003cstring\u003e&quot;,&quot;openMode&quot;:&quot;MIGRATE&quot;}],&quot;refreshableCloneConfig&quot;:{&quot;isRefreshableClone&quot;:&quot;\u003cboolean\u003e&quot;}}]