CreateMigration.go

// This is an automatically generated code sample.
// To make this code sample work in your Oracle Cloud tenancy,
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
// boolean, number, and enum parameters with values not fitting your use case).

package main

import (
	"context"
	"fmt"

	"github.com/oracle/oci-go-sdk/v65/common"
	"github.com/oracle/oci-go-sdk/v65/databasemigration"
	"github.com/oracle/oci-go-sdk/v65/example/helpers"
)

func ExampleCreateMigration() {
	// Create a default authentication provider that uses the DEFAULT
	// profile in the configuration file.
	// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
	client, err := databasemigration.NewDatabaseMigrationClientWithConfigurationProvider(common.DefaultConfigProvider())
	helpers.FatalIfError(err)

	// Create a request and dependent object(s).

	req := databasemigration.CreateMigrationRequest{CreateMigrationDetails: databasemigration.CreateOracleMigrationDetails{AdvancedParameters: []databasemigration.MigrationParameterDetails{databasemigration.MigrationParameterDetails{DataType: databasemigration.AdvancedParameterDataTypesFloat,
		Name:  common.String("EXAMPLE-name-Value"),
		Value: common.String("EXAMPLE-value-Value")}},
		DisplayName: common.String("EXAMPLE-displayName-Value"),
		GgsDetails: &databasemigration.CreateOracleGgsDeploymentDetails{AcceptableLag: common.Int(3),
			Extract: &databasemigration.CreateExtract{LongTransDuration: common.Int(769),
				PerformanceProfile: databasemigration.ExtractPerformanceProfileLow},
			Replicat: &databasemigration.CreateReplicat{PerformanceProfile: databasemigration.ReplicatPerformanceProfileHigh}},
		IncludeObjects: []databasemigration.OracleDatabaseObject{databasemigration.OracleDatabaseObject{Type: common.String("EXAMPLE-type-Value"),
			IsOmitExcludedTableFromReplication: common.Bool(false),
			ObjectName:                         common.String("EXAMPLE-objectName-Value"),
			Owner:                              common.String("EXAMPLE-owner-Value")}},
		MigrationSettings: databasemigration.CreateOracleOnlineStandbyMigrationSettings{InitialLoadSettings: &databasemigration.CreateOracleInitialLoadSettings{DataPumpParameters: &databasemigration.CreateDataPumpParameters{Estimate: databasemigration.DataPumpEstimateBlocks,
			ExcludeParameters: []databasemigration.DataPumpExcludeParametersEnum{databasemigration.DataPumpExcludeParametersIndex,
				databasemigration.DataPumpExcludeParametersMaterializedView,
				databasemigration.DataPumpExcludeParametersMaterializedViewLog},
			ExportParallelismDegree: common.Int(120),
			ImportParallelismDegree: common.Int(81),
			IsCluster:               common.Bool(true),
			TableExistsAction:       databasemigration.DataPumpTableExistsActionTruncate},
			ExportDirectoryObject: &databasemigration.CreateDirectoryObject{Name: common.String("EXAMPLE-name-Value"),
				Path: common.String("EXAMPLE-path-Value")},
			ImportDirectoryObject: &databasemigration.CreateDirectoryObject{Name: common.String("EXAMPLE-name-Value"),
				Path: common.String("EXAMPLE-path-Value")},
			JobMode: databasemigration.JobModeOracleFull,
			MetadataRemaps: []databasemigration.MetadataRemap{databasemigration.MetadataRemap{Type: databasemigration.MetadataRemapTypeSchema,
				NewValue: common.String("EXAMPLE-newValue-Value"),
				OldValue: common.String("EXAMPLE-oldValue-Value")}},
			TablespaceDetails: databasemigration.CreateAdbDedicatedAutoCreateTablespaceDetails{IsAutoCreate: common.Bool(true),
				IsBigFile:       common.Bool(true),
				BlockSizeInKBs:  databasemigration.DataPumpTablespaceBlockSizesInKbSize32K,
				ExtendSizeInMBs: common.Int(1.2646381e+08)}},
			AdvancedParameters: []databasemigration.MigrationParameterDetails{databasemigration.MigrationParameterDetails{DataType: databasemigration.AdvancedParameterDataTypesInteger,
				Name:  common.String("EXAMPLE-name-Value"),
				Value: common.String("EXAMPLE-value-Value")}},
			AdvisorSettings: &databasemigration.CreateOracleAdvisorSettings{IsIgnoreErrors: common.Bool(false),
				IsSkipAdvisor: common.Bool(false)},
			GgsDetails: &databasemigration.CreateOracleGgsDeploymentDetails{AcceptableLag: common.Int(14),
				Extract: &databasemigration.CreateExtract{LongTransDuration: common.Int(779),
					PerformanceProfile: databasemigration.ExtractPerformanceProfileMedium},
				Replicat: &databasemigration.CreateReplicat{PerformanceProfile: databasemigration.ReplicatPerformanceProfileLow}},
			IncludeObjects: []databasemigration.OracleDatabaseObject{databasemigration.OracleDatabaseObject{IsOmitExcludedTableFromReplication: common.Bool(true),
				ObjectName: common.String("EXAMPLE-objectName-Value"),
				Owner:      common.String("EXAMPLE-owner-Value"),
				Type:       common.String("EXAMPLE-type-Value")}},
			SourceContainerDatabaseConnectionId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sourceContainerDatabaseConnectionId-Value"),
			SourceStandbyDatabaseConnectionId:   common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sourceStandbyDatabaseConnectionId-Value"),
			BulkIncludeExcludeData:              common.String("EXAMPLE-bulkIncludeExcludeData-Value"),
			DataTransferMediumDetails: databasemigration.CreateOracleNfsDataTransferMediumDetails{ObjectStorageBucket: &databasemigration.CreateObjectStoreBucket{BucketName: common.String("EXAMPLE-bucketName-Value"),
				NamespaceName: common.String("EXAMPLE-namespaceName-Value")},
				SharedStorageMountTargetId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sharedStorageMountTargetId-Value"),
				Source:                     databasemigration.CurlTransferDetails{WalletLocation: common.String("EXAMPLE-walletLocation-Value")},
				Target:                     databasemigration.CurlTransferDetails{WalletLocation: common.String("EXAMPLE-walletLocation-Value")}},
			ExcludeObjects: []databasemigration.OracleDatabaseObject{databasemigration.OracleDatabaseObject{IsOmitExcludedTableFromReplication: common.Bool(true),
				ObjectName: common.String("EXAMPLE-objectName-Value"),
				Owner:      common.String("EXAMPLE-owner-Value"),
				Type:       common.String("EXAMPLE-type-Value")}},
			HubDetails: &databasemigration.CreateGoldenGateHubDetails{KeyId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value"),
				Replicat: &databasemigration.CreateReplicat{PerformanceProfile: databasemigration.ReplicatPerformanceProfileHigh},
				RestAdminCredentials: &databasemigration.CreateAdminCredentials{Password: common.String("EXAMPLE-password-Value"),
					Username: common.String("EXAMPLE-username-Value")},
				Url:           common.String("EXAMPLE-url-Value"),
				VaultId:       common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value"),
				AcceptableLag: common.Int(16),
				ComputeId:     common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-computeId-Value"),
				Extract: &databasemigration.CreateExtract{LongTransDuration: common.Int(935),
					PerformanceProfile: databasemigration.ExtractPerformanceProfileMedium}}},
		SourceStandbyDatabaseConnectionId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sourceStandbyDatabaseConnectionId-Value"),
		DefinedTags:                       map[string]map[string]interface{}{"EXAMPLE_KEY_fcQMc": map[string]interface{}{"EXAMPLE_KEY_pbyER": "EXAMPLE--Value"}},
		FreeformTags:                      map[string]string{"EXAMPLE_KEY_pmUd1": "EXAMPLE_VALUE_GmsIuHjuVc71W9nuGjo5"},
		HubDetails: &databasemigration.CreateGoldenGateHubDetails{Extract: &databasemigration.CreateExtract{LongTransDuration: common.Int(796),
			PerformanceProfile: databasemigration.ExtractPerformanceProfileMedium},
			KeyId:    common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value"),
			Replicat: &databasemigration.CreateReplicat{PerformanceProfile: databasemigration.ReplicatPerformanceProfileHigh},
			RestAdminCredentials: &databasemigration.CreateAdminCredentials{Username: common.String("EXAMPLE-username-Value"),
				Password: common.String("EXAMPLE-password-Value")},
			Url:           common.String("EXAMPLE-url-Value"),
			VaultId:       common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value"),
			AcceptableLag: common.Int(0),
			ComputeId:     common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-computeId-Value")},
		SourceContainerDatabaseConnectionId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sourceContainerDatabaseConnectionId-Value"),
		AdvisorSettings: &databasemigration.CreateOracleAdvisorSettings{IsSkipAdvisor: common.Bool(true),
			IsIgnoreErrors: common.Bool(true)},
		AssessmentId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-assessmentId-Value"),
		Description:  common.String("EXAMPLE-description-Value"),
		ExcludeObjects: []databasemigration.OracleDatabaseObject{databasemigration.OracleDatabaseObject{IsOmitExcludedTableFromReplication: common.Bool(false),
			ObjectName: common.String("EXAMPLE-objectName-Value"),
			Owner:      common.String("EXAMPLE-owner-Value"),
			Type:       common.String("EXAMPLE-type-Value")}},
		InitialLoadSettings: &databasemigration.CreateOracleInitialLoadSettings{TablespaceDetails: databasemigration.CreateAdbDedicatedAutoCreateTablespaceDetails{IsBigFile: common.Bool(true),
			BlockSizeInKBs:  databasemigration.DataPumpTablespaceBlockSizesInKbSize32K,
			ExtendSizeInMBs: common.Int(3.0548758e+07),
			IsAutoCreate:    common.Bool(false)},
			DataPumpParameters: &databasemigration.CreateDataPumpParameters{Estimate: databasemigration.DataPumpEstimateStatistics,
				ExcludeParameters: []databasemigration.DataPumpExcludeParametersEnum{databasemigration.DataPumpExcludeParametersIndex,
					databasemigration.DataPumpExcludeParametersMaterializedView,
					databasemigration.DataPumpExcludeParametersMaterializedViewLog},
				ExportParallelismDegree: common.Int(21),
				ImportParallelismDegree: common.Int(101),
				IsCluster:               common.Bool(true),
				TableExistsAction:       databasemigration.DataPumpTableExistsActionUnspecified},
			ExportDirectoryObject: &databasemigration.CreateDirectoryObject{Name: common.String("EXAMPLE-name-Value"),
				Path: common.String("EXAMPLE-path-Value")},
			ImportDirectoryObject: &databasemigration.CreateDirectoryObject{Name: common.String("EXAMPLE-name-Value"),
				Path: common.String("EXAMPLE-path-Value")},
			JobMode: databasemigration.JobModeOracleSchema,
			MetadataRemaps: []databasemigration.MetadataRemap{databasemigration.MetadataRemap{OldValue: common.String("EXAMPLE-oldValue-Value"),
				Type:     databasemigration.MetadataRemapTypeDatafile,
				NewValue: common.String("EXAMPLE-newValue-Value")}}},
		SourceDatabaseConnectionId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-sourceDatabaseConnectionId-Value"),
		BulkIncludeExcludeData:     common.String("EXAMPLE-bulkIncludeExcludeData-Value"),
		CompartmentId:              common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value"),
		DataTransferMediumDetails: databasemigration.CreateOracleAwsS3DataTransferMediumDetails{AccessKeyId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-accessKeyId-Value"),
			Name: common.String("EXAMPLE-name-Value"),
			ObjectStorageBucket: &databasemigration.ObjectStoreBucket{BucketName: common.String("EXAMPLE-bucketName-Value"),
				NamespaceName: common.String("EXAMPLE-namespaceName-Value")},
			Region:          common.String("EXAMPLE-region-Value"),
			SecretAccessKey: common.String("EXAMPLE-secretAccessKey-Value")},
		TargetDatabaseConnectionId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-targetDatabaseConnectionId-Value"),
		Type:                       databasemigration.MigrationTypesOnline},
		OpcRequestId:  common.String("UDJDZBYOXSRQUGHURME3<unique_ID>"),
		OpcRetryToken: common.String("EXAMPLE-opcRetryToken-Value")}

	// Send the request using the service client
	resp, err := client.CreateMigration(context.Background(), req)
	helpers.FatalIfError(err)

	// Retrieve value from the response.
	fmt.Println(resp)
}
Oracle Cloud Infrastructure Documentation
