Create a Migration.
POST {{baseUrl}}/migrations
Create a Migration resource that contains all the details to perform the database migration operation, such as source and destination database details, credentials, etc.
Request Body
{"compartmentId"=>"<string>", "type"=>"ONLINE", "sourceDatabaseConnectionId"=>"<string>", "targetDatabaseConnectionId"=>"<string>", "advisorSettings"=>{"isIgnoreErrors"=>false, "isSkipAdvisor"=>false}, "agentId"=>"<string>", "csvText"=>"<string>", "dataTransferMediumDetails"=>{"awsS3Details"=>{"name"=>"<string>", "region"=>"<string>", "accessKeyId"=>"<string>", "secretAccessKey"=>"<string>", "objectStorageBucket"=>{"namespaceName"=>"<string>", "bucketName"=>"<string>"}}, "databaseLinkDetails"=>{"name"=>"<string>", "walletBucket"=>{"namespaceName"=>"<string>", "bucketName"=>"<string>"}}, "objectStorageDetails"=>{"namespaceName"=>"<string>", "bucketName"=>"<string>"}}, "dataTransferMediumDetailsV2"=>{"type"=>"OBJECT_STORAGE"}, "datapumpSettings"=>{"dataPumpParameters"=>{"estimate"=>"STATISTICS", "excludeParameters"=>["INDEX", "MATERIALIZED_VIEW_LOG"], "exportParallelismDegree"=>"<integer>", "importParallelismDegree"=>"<integer>", "isCluster"=>true, "tableExistsAction"=>"SKIP"}, "exportDirectoryObject"=>{"name"=>"<string>", "path"=>"<string>"}, "importDirectoryObject"=>{"name"=>"<string>", "path"=>"<string>"}, "jobMode"=>"TRANSPORTABLE", "metadataRemaps"=>[{"type"=>"DATAFILE", "oldValue"=>"<string>", "newValue"=>"<string>"}, {"type"=>"DATAFILE", "oldValue"=>"<string>", "newValue"=>"<string>"}], "tablespaceDetails"=>{"targetType"=>"ADB_S_REMAP"}}, "displayName"=>"<string>", "dumpTransferDetails"=>{"sharedStorageMountTargetId"=>"<string>", "source"=>{"kind"=>"CURL", "walletLocation"=>"<string>"}, "target"=>{"kind"=>"CURL", "walletLocation"=>"<string>"}}, "excludeObjects"=>[{"owner"=>"<string>", "objectName"=>"<string>", "isOmitExcludedTableFromReplication"=>false, "type"=>"<string>"}, {"owner"=>"<string>", "objectName"=>"<string>", "isOmitExcludedTableFromReplication"=>false, "type"=>"<string>"}], "freeformTags"=>{"eiusmodb"=>"<string>", "ind5b"=>"<string>"}, "goldenGateDetails"=>{"hub"=>{"restAdminCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "url"=>"<string>", "computeId"=>"<string>", "sourceContainerDbAdminCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "sourceDbAdminCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "sourceMicroservicesDeploymentName"=>"Marketplace", "targetDbAdminCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "targetMicroservicesDeploymentName"=>"Marketplace"}, "settings"=>{"acceptableLag"=>30, "extract"=>{"longTransDuration"=>"<integer>", "performanceProfile"=>"MEDIUM"}, "replicat"=>{"mapParallelism"=>4, "maxApplyParallelism"=>50, "minApplyParallelism"=>4, "performanceProfile"=>"HIGH"}}}, "goldenGateServiceDetails"=>{"settings"=>{"acceptableLag"=>30, "extract"=>{"longTransDuration"=>"<integer>", "performanceProfile"=>"MEDIUM"}, "replicat"=>{"mapParallelism"=>4, "maxApplyParallelism"=>50, "minApplyParallelism"=>4, "performanceProfile"=>"HIGH"}}, "sourceContainerDbCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "sourceDbCredentials"=>{"username"=>"<string>", "password"=>"<string>"}, "targetDbCredentials"=>{"username"=>"<string>", "password"=>"<string>"}}, "includeObjects"=>[{"owner"=>"<string>", "objectName"=>"<string>", "isOmitExcludedTableFromReplication"=>false, "type"=>"<string>"}, {"owner"=>"<string>", "objectName"=>"<string>", "isOmitExcludedTableFromReplication"=>false, "type"=>"<string>"}], "sourceContainerDatabaseConnectionId"=>"<string>", "vaultDetails"=>{"compartmentId"=>"<string>", "vaultId"=>"<string>", "keyId"=>"<string>"}}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
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. | |||
opc-request-id | string | Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a | |
particular request, please provide the request ID. | |||
Content-Type | string | ||
Accept | string |
RESPONSES
status: Created
{"id":"\u003cstring\u003e","displayName":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e","type":"OFFLINE","sourceDatabaseConnectionId":"\u003cstring\u003e","targetDatabaseConnectionId":"\u003cstring\u003e","timeCreated":"\u003cdateTime\u003e","lifecycleState":"ACTIVE","advisorSettings":{"isIgnoreErrors":false,"isSkipAdvisor":false},"agentId":"\u003cstring\u003e","credentialsSecretId":"\u003cstring\u003e","dataTransferMediumDetails":{"awsS3Details":{"name":"\u003cstring\u003e","region":"\u003cstring\u003e"},"databaseLinkDetails":{"name":"\u003cstring\u003e","walletBucket":{"namespaceName":"\u003cstring\u003e","bucketName":"\u003cstring\u003e"}},"objectStorageDetails":{"namespaceName":"\u003cstring\u003e","bucketName":"\u003cstring\u003e"}},"dataTransferMediumDetailsV2":{"type":"OBJECT_STORAGE"},"datapumpSettings":{"dataPumpParameters":{"estimate":"STATISTICS","excludeParameters":["INDEX","MATERIALIZED_VIEW_LOG"],"exportParallelismDegree":"\u003cinteger\u003e","importParallelismDegree":"\u003cinteger\u003e","isCluster":true,"tableExistsAction":"SKIP"},"exportDirectoryObject":{"name":"\u003cstring\u003e","path":"\u003cstring\u003e"},"importDirectoryObject":{"name":"\u003cstring\u003e","path":"\u003cstring\u003e"},"jobMode":"TRANSPORTABLE","metadataRemaps":[{"type":"DATAFILE","oldValue":"\u003cstring\u003e","newValue":"\u003cstring\u003e"},{"type":"TABLESPACE","oldValue":"\u003cstring\u003e","newValue":"\u003cstring\u003e"}],"tablespaceDetails":{"targetType":"ADB_D_REMAP"}},"definedTags":{"cillum_89c":{"dolored":{}},"mollit_e":{"velit15e":{},"fugiat_ad9":{}},"qui342":{"sit60b":{},"aliquip07c":{}},"voluptate_fed":{"labore_65":{}},"reprehenderit6e5":{"consequatd3":{},"estc89":{}}},"dumpTransferDetails":{"sharedStorageMountTargetId":"\u003cstring\u003e","source":{"kind":"CURL","walletLocation":"\u003cstring\u003e"},"target":{"kind":"OCI_CLI","walletLocation":"\u003cstring\u003e"}},"excludeObjects":[{"owner":"\u003cstring\u003e","objectName":"\u003cstring\u003e","isOmitExcludedTableFromReplication":false,"type":"\u003cstring\u003e"},{"owner":"\u003cstring\u003e","objectName":"\u003cstring\u003e","isOmitExcludedTableFromReplication":false,"type":"\u003cstring\u003e"}],"executingJobId":"\u003cstring\u003e","freeformTags":{"sed_083":"\u003cstring\u003e","Ut14":"\u003cstring\u003e","id8e":"\u003cstring\u003e"},"goldenGateDetails":{"hub":{"restAdminCredentials":{"username":"\u003cstring\u003e"},"sourceDbAdminCredentials":{"username":"\u003cstring\u003e"},"targetDbAdminCredentials":{"username":"\u003cstring\u003e"},"url":"\u003cstring\u003e","sourceMicroservicesDeploymentName":"\u003cstring\u003e","targetMicroservicesDeploymentName":"\u003cstring\u003e","computeId":"\u003cstring\u003e","sourceContainerDbAdminCredentials":{"username":"\u003cstring\u003e"}},"settings":{"acceptableLag":30,"extract":{"longTransDuration":"\u003cinteger\u003e","performanceProfile":"MEDIUM"},"replicat":{"mapParallelism":4,"maxApplyParallelism":50,"minApplyParallelism":4,"performanceProfile":"HIGH"}}},"goldenGateServiceDetails":{"ggsDeployment":{"deploymentId":"\u003cstring\u003e","ggsAdminCredentialsSecretId":"\u003cstring\u003e"},"settings":{"acceptableLag":30,"extract":{"longTransDuration":"\u003cinteger\u003e","performanceProfile":"MEDIUM"},"replicat":{"mapParallelism":4,"maxApplyParallelism":50,"minApplyParallelism":4,"performanceProfile":"HIGH"}},"sourceContainerReplicationCredentials":{"username":"\u003cstring\u003e"},"sourceReplicationAdminCredentials":{"username":"\u003cstring\u003e"},"targetReplicationCredentials":{"username":"\u003cstring\u003e"}},"includeObjects":[{"owner":"\u003cstring\u003e","objectName":"\u003cstring\u003e","isOmitExcludedTableFromReplication":false,"type":"\u003cstring\u003e"},{"owner":"\u003cstring\u003e","objectName":"\u003cstring\u003e","isOmitExcludedTableFromReplication":false,"type":"\u003cstring\u003e"}],"lifecycleDetails":"DONE","sourceContainerDatabaseConnectionId":"\u003cstring\u003e","systemTags":{"eu_7":{"mollit_d5":{},"Ut0f5":{}},"dolore_7bc":{"ullamcof_":{}},"dobb":{"anim_ce1":{},"pariatur_2":{},"qui_9dc":{},"dolore72d":{},"esse0f":{}}},"timeLastMigration":"\u003cdateTime\u003e","timeUpdated":"\u003cdateTime\u003e","vaultDetails":{"compartmentId":"\u003cstring\u003e","vaultId":"\u003cstring\u003e","keyId":"\u003cstring\u003e"},"waitAfter":"ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC"}