Gets a list of tablespaces for a Managed Database.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/tablespaces?name=<string>&sortBy=TIMECREATED&sortOrder=ASC&page=<string>&limit=10
Gets the list of tablespaces for the specified managedDatabaseId.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
name | string | A filter to return only resources that match the entire name. | |
sortBy | string | The field to sort information by. Only one sortOrder can be used. The default sort order | |
for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending. | |||
The ‘NAME’ sort order is case-sensitive. | |||
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. | |
page | string | The page token representing the page from where the next set of paginated results | |
are retrieved. This is usually retrieved from a previous list call. | |||
limit | number | The maximum number of records returned in the paginated response. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"name":"\u003cstring\u003e","type":"LOST_WRITE_PROTECTION","allocatedSizeKB":"\u003cnumber\u003e","allocationType":"USER","blockSizeBytes":"\u003cnumber\u003e","compressFor":"QUERY_HIGH","datafiles":[{"name":"\u003cstring\u003e","allocatedSizeKB":"\u003cnumber\u003e","freeSpaceKB":"\u003cnumber\u003e","incrementBy":"\u003cnumber\u003e","instanceId":"\u003cnumber\u003e","isAutoExtensible":"\u003cboolean\u003e","lostWriteProtect":"ENABLED","maxSizeKB":"\u003cnumber\u003e","onlineStatus":"ONLINE","shared":"SHARED","status":"ONLINE","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"},{"name":"\u003cstring\u003e","allocatedSizeKB":"\u003cnumber\u003e","freeSpaceKB":"\u003cnumber\u003e","incrementBy":"\u003cnumber\u003e","instanceId":"\u003cnumber\u003e","isAutoExtensible":"\u003cboolean\u003e","lostWriteProtect":"ENABLED","maxSizeKB":"\u003cnumber\u003e","onlineStatus":"ONLINE","shared":"LOCAL_FOR_RIM","status":"AVAILABLE","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"}],"defaultCellMemory":"\u003cstring\u003e","defaultInMemory":"DISABLED","defaultInMemoryCompression":"FOR_QUERY_HIGH","defaultInMemoryDistribute":"BY_PARTITION","defaultInMemoryDuplicate":"DUPLICATE","defaultInMemoryPriority":"HIGH","defaultInMemoryService":"USER_DEFINED","defaultInMemoryServiceName":"\u003cstring\u003e","defaultIndexCompression":"ENABLED","defaultTableCompression":"ENABLED","extentManagement":"DICTIONARY","freeSpaceKB":"\u003cnumber\u003e","indexCompressFor":"ADVANCED_LOW","isBigfile":"\u003cboolean\u003e","isChunkTablespace":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","isEncrypted":"\u003cboolean\u003e","isForceLogging":"\u003cboolean\u003e","isPluggedIn":"\u003cboolean\u003e","logging":"NOLOGGING","lostWriteProtect":"PROTECT_OFF","maxSizeKB":"\u003cnumber\u003e","predicateEvaluation":"STORAGE","retention":"NOT_APPLY","segmentSpaceManagement":"AUTO","shared":"SHARED","status":"ONLINE","tempGroup":"\u003cstring\u003e","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"},{"name":"\u003cstring\u003e","type":"LOST_WRITE_PROTECTION","allocatedSizeKB":"\u003cnumber\u003e","allocationType":"SYSTEM","blockSizeBytes":"\u003cnumber\u003e","compressFor":"QUERY_LOW","datafiles":[{"name":"\u003cstring\u003e","allocatedSizeKB":"\u003cnumber\u003e","freeSpaceKB":"\u003cnumber\u003e","incrementBy":"\u003cnumber\u003e","instanceId":"\u003cnumber\u003e","isAutoExtensible":"\u003cboolean\u003e","lostWriteProtect":"ENABLED","maxSizeKB":"\u003cnumber\u003e","onlineStatus":"ONLINE","shared":"LOCAL_FOR_RIM","status":"UNKNOWN","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"},{"name":"\u003cstring\u003e","allocatedSizeKB":"\u003cnumber\u003e","freeSpaceKB":"\u003cnumber\u003e","incrementBy":"\u003cnumber\u003e","instanceId":"\u003cnumber\u003e","isAutoExtensible":"\u003cboolean\u003e","lostWriteProtect":"PROTECT_OFF","maxSizeKB":"\u003cnumber\u003e","onlineStatus":"OFFLINE","shared":"LOCAL_FOR_RIM","status":"OFFLINE","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"}],"defaultCellMemory":"\u003cstring\u003e","defaultInMemory":"ENABLED","defaultInMemoryCompression":"NO_MEMCOMPRESS","defaultInMemoryDistribute":"BY_SUBPARTITION","defaultInMemoryDuplicate":"DUPLICATE","defaultInMemoryPriority":"NONE","defaultInMemoryService":"ALL","defaultInMemoryServiceName":"\u003cstring\u003e","defaultIndexCompression":"DISABLED","defaultTableCompression":"DISABLED","extentManagement":"DICTIONARY","freeSpaceKB":"\u003cnumber\u003e","indexCompressFor":"ADVANCED_HIGH","isBigfile":"\u003cboolean\u003e","isChunkTablespace":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","isEncrypted":"\u003cboolean\u003e","isForceLogging":"\u003cboolean\u003e","isPluggedIn":"\u003cboolean\u003e","logging":"LOGGING","lostWriteProtect":"SUSPEND","maxSizeKB":"\u003cnumber\u003e","predicateEvaluation":"HOST","retention":"NOT_APPLY","segmentSpaceManagement":"MANUAL","shared":"LOCAL_ON_LEAF","status":"READ_ONLY","tempGroup":"\u003cstring\u003e","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"}]}