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

KeyDatatypeRequiredDescription
opc-retry-tokenstringA 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-idstringUnique Oracle-assigned identifier for the request. If you need to contact Oracle about a
particular request, please provide the request ID.
Content-Typestring
Acceptstring

RESPONSES

status: Created

{&quot;id&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;OFFLINE&quot;,&quot;sourceDatabaseConnectionId&quot;:&quot;\u003cstring\u003e&quot;,&quot;targetDatabaseConnectionId&quot;:&quot;\u003cstring\u003e&quot;,&quot;timeCreated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;lifecycleState&quot;:&quot;ACTIVE&quot;,&quot;advisorSettings&quot;:{&quot;isIgnoreErrors&quot;:false,&quot;isSkipAdvisor&quot;:false},&quot;agentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;credentialsSecretId&quot;:&quot;\u003cstring\u003e&quot;,&quot;dataTransferMediumDetails&quot;:{&quot;awsS3Details&quot;:{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;region&quot;:&quot;\u003cstring\u003e&quot;},&quot;databaseLinkDetails&quot;:{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;walletBucket&quot;:{&quot;namespaceName&quot;:&quot;\u003cstring\u003e&quot;,&quot;bucketName&quot;:&quot;\u003cstring\u003e&quot;}},&quot;objectStorageDetails&quot;:{&quot;namespaceName&quot;:&quot;\u003cstring\u003e&quot;,&quot;bucketName&quot;:&quot;\u003cstring\u003e&quot;}},&quot;dataTransferMediumDetailsV2&quot;:{&quot;type&quot;:&quot;OBJECT_STORAGE&quot;},&quot;datapumpSettings&quot;:{&quot;dataPumpParameters&quot;:{&quot;estimate&quot;:&quot;STATISTICS&quot;,&quot;excludeParameters&quot;:[&quot;INDEX&quot;,&quot;MATERIALIZED_VIEW_LOG&quot;],&quot;exportParallelismDegree&quot;:&quot;\u003cinteger\u003e&quot;,&quot;importParallelismDegree&quot;:&quot;\u003cinteger\u003e&quot;,&quot;isCluster&quot;:true,&quot;tableExistsAction&quot;:&quot;SKIP&quot;},&quot;exportDirectoryObject&quot;:{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;path&quot;:&quot;\u003cstring\u003e&quot;},&quot;importDirectoryObject&quot;:{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;path&quot;:&quot;\u003cstring\u003e&quot;},&quot;jobMode&quot;:&quot;TRANSPORTABLE&quot;,&quot;metadataRemaps&quot;:[{&quot;type&quot;:&quot;DATAFILE&quot;,&quot;oldValue&quot;:&quot;\u003cstring\u003e&quot;,&quot;newValue&quot;:&quot;\u003cstring\u003e&quot;},{&quot;type&quot;:&quot;TABLESPACE&quot;,&quot;oldValue&quot;:&quot;\u003cstring\u003e&quot;,&quot;newValue&quot;:&quot;\u003cstring\u003e&quot;}],&quot;tablespaceDetails&quot;:{&quot;targetType&quot;:&quot;ADB_D_REMAP&quot;}},&quot;definedTags&quot;:{&quot;cillum_89c&quot;:{&quot;dolored&quot;:{}},&quot;mollit_e&quot;:{&quot;velit15e&quot;:{},&quot;fugiat_ad9&quot;:{}},&quot;qui342&quot;:{&quot;sit60b&quot;:{},&quot;aliquip07c&quot;:{}},&quot;voluptate_fed&quot;:{&quot;labore_65&quot;:{}},&quot;reprehenderit6e5&quot;:{&quot;consequatd3&quot;:{},&quot;estc89&quot;:{}}},&quot;dumpTransferDetails&quot;:{&quot;sharedStorageMountTargetId&quot;:&quot;\u003cstring\u003e&quot;,&quot;source&quot;:{&quot;kind&quot;:&quot;CURL&quot;,&quot;walletLocation&quot;:&quot;\u003cstring\u003e&quot;},&quot;target&quot;:{&quot;kind&quot;:&quot;OCI_CLI&quot;,&quot;walletLocation&quot;:&quot;\u003cstring\u003e&quot;}},&quot;excludeObjects&quot;:[{&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isOmitExcludedTableFromReplication&quot;:false,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isOmitExcludedTableFromReplication&quot;:false,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;executingJobId&quot;:&quot;\u003cstring\u003e&quot;,&quot;freeformTags&quot;:{&quot;sed_083&quot;:&quot;\u003cstring\u003e&quot;,&quot;Ut14&quot;:&quot;\u003cstring\u003e&quot;,&quot;id8e&quot;:&quot;\u003cstring\u003e&quot;},&quot;goldenGateDetails&quot;:{&quot;hub&quot;:{&quot;restAdminCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;},&quot;sourceDbAdminCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;},&quot;targetDbAdminCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;},&quot;url&quot;:&quot;\u003cstring\u003e&quot;,&quot;sourceMicroservicesDeploymentName&quot;:&quot;\u003cstring\u003e&quot;,&quot;targetMicroservicesDeploymentName&quot;:&quot;\u003cstring\u003e&quot;,&quot;computeId&quot;:&quot;\u003cstring\u003e&quot;,&quot;sourceContainerDbAdminCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;}},&quot;settings&quot;:{&quot;acceptableLag&quot;:30,&quot;extract&quot;:{&quot;longTransDuration&quot;:&quot;\u003cinteger\u003e&quot;,&quot;performanceProfile&quot;:&quot;MEDIUM&quot;},&quot;replicat&quot;:{&quot;mapParallelism&quot;:4,&quot;maxApplyParallelism&quot;:50,&quot;minApplyParallelism&quot;:4,&quot;performanceProfile&quot;:&quot;HIGH&quot;}}},&quot;goldenGateServiceDetails&quot;:{&quot;ggsDeployment&quot;:{&quot;deploymentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;ggsAdminCredentialsSecretId&quot;:&quot;\u003cstring\u003e&quot;},&quot;settings&quot;:{&quot;acceptableLag&quot;:30,&quot;extract&quot;:{&quot;longTransDuration&quot;:&quot;\u003cinteger\u003e&quot;,&quot;performanceProfile&quot;:&quot;MEDIUM&quot;},&quot;replicat&quot;:{&quot;mapParallelism&quot;:4,&quot;maxApplyParallelism&quot;:50,&quot;minApplyParallelism&quot;:4,&quot;performanceProfile&quot;:&quot;HIGH&quot;}},&quot;sourceContainerReplicationCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;},&quot;sourceReplicationAdminCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;},&quot;targetReplicationCredentials&quot;:{&quot;username&quot;:&quot;\u003cstring\u003e&quot;}},&quot;includeObjects&quot;:[{&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isOmitExcludedTableFromReplication&quot;:false,&quot;type&quot;:&quot;\u003cstring\u003e&quot;},{&quot;owner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isOmitExcludedTableFromReplication&quot;:false,&quot;type&quot;:&quot;\u003cstring\u003e&quot;}],&quot;lifecycleDetails&quot;:&quot;DONE&quot;,&quot;sourceContainerDatabaseConnectionId&quot;:&quot;\u003cstring\u003e&quot;,&quot;systemTags&quot;:{&quot;eu_7&quot;:{&quot;mollit_d5&quot;:{},&quot;Ut0f5&quot;:{}},&quot;dolore_7bc&quot;:{&quot;ullamcof_&quot;:{}},&quot;dobb&quot;:{&quot;anim_ce1&quot;:{},&quot;pariatur_2&quot;:{},&quot;qui_9dc&quot;:{},&quot;dolore72d&quot;:{},&quot;esse0f&quot;:{}}},&quot;timeLastMigration&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;timeUpdated&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;vaultDetails&quot;:{&quot;compartmentId&quot;:&quot;\u003cstring\u003e&quot;,&quot;vaultId&quot;:&quot;\u003cstring\u003e&quot;,&quot;keyId&quot;:&quot;\u003cstring\u003e&quot;},&quot;waitAfter&quot;:&quot;ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC&quot;}