# 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).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
database_migration_client =
OCI::DatabaseMigration::DatabaseMigrationClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
update_migration_response =
database_migration_client.update_migration(
'ocid1.test.oc1..<unique_ID>EXAMPLE-migrationId-Value',
OCI::DatabaseMigration::Models::UpdateMigrationDetails.new(
type: 'ONLINE',
display_name: 'EXAMPLE-displayName-Value',
agent_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-agentId-Value',
source_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceDatabaseConnectionId-Value',
source_container_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceContainerDatabaseConnectionId-Value',
target_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-targetDatabaseConnectionId-Value',
data_transfer_medium_details_v2:
OCI::DatabaseMigration::Models::DbLinkDataTransferMediumDetails.new(
type: 'DBLINK',
object_storage_bucket:
OCI::DatabaseMigration::Models::ObjectStoreBucket.new(
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
),
name: 'EXAMPLE-name-Value'
),
data_transfer_medium_details:
OCI::DatabaseMigration::Models::UpdateDataTransferMediumDetails.new(
database_link_details:
OCI::DatabaseMigration::Models::UpdateDatabaseLinkDetails.new(
name: 'EXAMPLE-name-Value',
wallet_bucket:
OCI::DatabaseMigration::Models::UpdateObjectStoreBucket.new(
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
)
),
object_storage_details:
OCI::DatabaseMigration::Models::UpdateObjectStoreBucket.new(
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
),
aws_s3_details:
OCI::DatabaseMigration::Models::UpdateAwsS3Details.new(
name: 'EXAMPLE-name-Value',
region: 'EXAMPLE-region-Value',
access_key_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-accessKeyId-Value',
secret_access_key: 'EXAMPLE-secretAccessKey-Value'
)
),
dump_transfer_details:
OCI::DatabaseMigration::Models::UpdateDumpTransferDetails.new(
source:
OCI::DatabaseMigration::Models::UpdateCurlTransferDetails.new(
kind: 'CURL', wallet_location: 'EXAMPLE-walletLocation-Value'
),
target:
OCI::DatabaseMigration::Models::UpdateOciCliDumpTransferDetails.new(
kind: 'OCI_CLI',
oci_home: 'EXAMPLE-ociHome-Value',
wallet_location: 'EXAMPLE-walletLocation-Value'
),
shared_storage_mount_target_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sharedStorageMountTargetId-Value'
),
datapump_settings:
OCI::DatabaseMigration::Models::UpdateDataPumpSettings.new(
job_mode: 'SCHEMA',
data_pump_parameters:
OCI::DatabaseMigration::Models::UpdateDataPumpParameters.new(
is_cluster: false,
estimate: 'STATISTICS',
table_exists_action: 'REPLACE',
exclude_parameters: %w[
INDEX
MATERIALIZED_VIEW
MATERIALIZED_VIEW_LOG
],
import_parallelism_degree: 816,
export_parallelism_degree: 9
),
metadata_remaps: [
OCI::DatabaseMigration::Models::MetadataRemap.new(
type: 'TABLESPACE',
old_value: 'EXAMPLE-oldValue-Value',
new_value: 'EXAMPLE-newValue-Value'
)
],
tablespace_details:
OCI::DatabaseMigration::Models::UpdateADBServerlesTablespaceDetails
.new(target_type: 'ADB_S_REMAP'),
export_directory_object:
OCI::DatabaseMigration::Models::UpdateDirectoryObject.new(
name: 'EXAMPLE-name-Value', path: 'EXAMPLE-path-Value'
),
import_directory_object:
OCI::DatabaseMigration::Models::UpdateDirectoryObject.new(
name: 'EXAMPLE-name-Value', path: 'EXAMPLE-path-Value'
)
),
advisor_settings:
OCI::DatabaseMigration::Models::UpdateAdvisorSettings.new(
is_skip_advisor: false, is_ignore_errors: true
),
exclude_objects: [
OCI::DatabaseMigration::Models::DatabaseObject.new(
owner: 'EXAMPLE-owner-Value',
object_name: 'EXAMPLE-objectName-Value',
type: 'EXAMPLE-type-Value',
is_omit_excluded_table_from_replication: false
)
],
include_objects: [
OCI::DatabaseMigration::Models::DatabaseObject.new(
owner: 'EXAMPLE-owner-Value',
object_name: 'EXAMPLE-objectName-Value',
type: 'EXAMPLE-type-Value',
is_omit_excluded_table_from_replication: false
)
],
golden_gate_service_details:
OCI::DatabaseMigration::Models::UpdateGoldenGateServiceDetails.new(
source_db_credentials:
OCI::DatabaseMigration::Models::DatabaseCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
source_container_db_credentials:
OCI::DatabaseMigration::Models::DatabaseCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
target_db_credentials:
OCI::DatabaseMigration::Models::DatabaseCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
settings:
OCI::DatabaseMigration::Models::UpdateGoldenGateSettings.new(
extract:
OCI::DatabaseMigration::Models::UpdateExtract.new(
performance_profile: 'HIGH', long_trans_duration: 150
),
replicat:
OCI::DatabaseMigration::Models::UpdateReplicat.new(
performance_profile: 'LOW',
map_parallelism: 35,
min_apply_parallelism: 320,
max_apply_parallelism: 979
),
acceptable_lag: 5
)
),
golden_gate_details:
OCI::DatabaseMigration::Models::UpdateGoldenGateDetails.new(
hub:
OCI::DatabaseMigration::Models::UpdateGoldenGateHub.new(
rest_admin_credentials:
OCI::DatabaseMigration::Models::UpdateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
source_db_admin_credentials:
OCI::DatabaseMigration::Models::UpdateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
source_container_db_admin_credentials:
OCI::DatabaseMigration::Models::UpdateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
target_db_admin_credentials:
OCI::DatabaseMigration::Models::UpdateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
url: 'EXAMPLE-url-Value',
source_microservices_deployment_name:
'EXAMPLE-sourceMicroservicesDeploymentName-Value',
target_microservices_deployment_name:
'EXAMPLE-targetMicroservicesDeploymentName-Value',
compute_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-computeId-Value'
),
settings:
OCI::DatabaseMigration::Models::UpdateGoldenGateSettings.new(
extract:
OCI::DatabaseMigration::Models::UpdateExtract.new(
performance_profile: 'LOW', long_trans_duration: 477
),
replicat:
OCI::DatabaseMigration::Models::UpdateReplicat.new(
performance_profile: 'LOW',
map_parallelism: 43,
min_apply_parallelism: 232,
max_apply_parallelism: 156
),
acceptable_lag: 13
)
),
vault_details:
OCI::DatabaseMigration::Models::UpdateVaultDetails.new(
compartment_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
vault_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value',
key_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value'
),
freeform_tags: {
'EXAMPLE_KEY_oOtcD' => 'EXAMPLE_VALUE_nhIbkynMF8ZQH9hU2UW9'
},
defined_tags: {
'EXAMPLE_KEY_MvE83' => { 'EXAMPLE_KEY_tF0Jk' => 'EXAMPLE--Value' }
}
)
)
# Get the data from response
puts "#{update_migration_response.headers}"