Creates a tablespace.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/tablespaces
Creates a tablespace within the Managed Database specified by managedDatabaseId.
Request Body
{"name"=>"<string>", "autoExtendMaxSize"=>{"size"=>"<number>", "unit"=>"KILOBYTES"}, "autoExtendNextSize"=>{"size"=>"<number>", "unit"=>"TERABYTES"}, "blockSizeInKilobytes"=>nil, "credentialDetails"=>{"tablespaceAdminCredentialType"=>"SECRET", "username"=>"<string>", "role"=>"NORMAL"}, "dataFiles"=>["<string>", "<string>"], "databaseCredential"=>{"credentialType"=>"PASSWORD"}, "defaultCompress"=>"BASIC_COMPRESS", "encryptionAlgorithm"=>"<string>", "extentManagement"=>"AUTOALLOCATE", "extentUniformSize"=>{"size"=>"<number>", "unit"=>"MEGABYTES"}, "fileCount"=>"<integer>", "fileSize"=>{"size"=>"<number>", "unit"=>"GIGABYTES"}, "isAutoExtensible"=>"<boolean>", "isBigfile"=>"<boolean>", "isDefault"=>"<boolean>", "isEncrypted"=>"<boolean>", "isMaxSizeUnlimited"=>"<boolean>", "isReusable"=>"<boolean>", "segmentManagement"=>"MANUAL", "status"=>"READ_WRITE", "type"=>"TEMPORARY"}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A token that uniquely identifies a request so it can be retried in case of a timeout or | |
server error without risk of executing that same action again. Retry tokens expire after 24 | |||
hours, but can be invalidated before then due to conflicting operations. For example, if a resource | |||
has been deleted and purged from the system, then a retry of the original creation request | |||
might be rejected. | |||
Content-Type | string | ||
Accept | string |
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"}