Qodex.ai

Gets the details of the tablespace.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/tablespaces/:tablespaceName

Gets the details of the tablespace specified by tablespaceName within the Managed Database specified by managedDatabaseId.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{"name":"\u003cstring\u003e","type":"PERMANENT","allocatedSizeKB":"\u003cnumber\u003e","allocationType":"UNIFORM","blockSizeBytes":"\u003cnumber\u003e","compressFor":"ARCHIVE_HIGH","datafiles":[{"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":"SHARED","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":"ONLINE","shared":"LOCAL_FOR_RIM","status":"UNKNOWN","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"}],"defaultCellMemory":"\u003cstring\u003e","defaultInMemory":"DISABLED","defaultInMemoryCompression":"NO_MEMCOMPRESS","defaultInMemoryDistribute":"BY_PARTITION","defaultInMemoryDuplicate":"DUPLICATE_ALL","defaultInMemoryPriority":"CRITICAL","defaultInMemoryService":"USER_DEFINED","defaultInMemoryServiceName":"\u003cstring\u003e","defaultIndexCompression":"ENABLED","defaultTableCompression":"ENABLED","extentManagement":"LOCAL","freeSpaceKB":"\u003cnumber\u003e","indexCompressFor":"NONE","isBigfile":"\u003cboolean\u003e","isChunkTablespace":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","isEncrypted":"\u003cboolean\u003e","isForceLogging":"\u003cboolean\u003e","isPluggedIn":"\u003cboolean\u003e","logging":"LOGGING","lostWriteProtect":"ENABLED","maxSizeKB":"\u003cnumber\u003e","predicateEvaluation":"STORAGE","retention":"NOT_APPLY","segmentSpaceManagement":"AUTO","shared":"SHARED","status":"READ_ONLY","tempGroup":"\u003cstring\u003e","usedPercentAllocated":"\u003cdouble\u003e","usedPercentAvailable":"\u003cdouble\u003e","usedSpaceKB":"\u003cnumber\u003e","userSizeKB":"\u003cnumber\u003e"}