# 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::UpdateOracleMigrationDetails.new(
database_combination: 'ORACLE',
description: 'EXAMPLE-description-Value',
type: 'OFFLINE',
display_name: 'EXAMPLE-displayName-Value',
source_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceDatabaseConnectionId-Value',
target_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-targetDatabaseConnectionId-Value',
freeform_tags: {
'EXAMPLE_KEY_e4U1i' => 'EXAMPLE_VALUE_wQkNfwFy9vMLGIDwMrYX'
},
defined_tags: {
'EXAMPLE_KEY_BHCqq' => { 'EXAMPLE_KEY_jI7cX' => 'EXAMPLE--Value' }
},
data_transfer_medium_details:
OCI::DatabaseMigration::Models::UpdateOracleNfsDataTransferMediumDetails
.new(
type: 'NFS',
object_storage_bucket:
OCI::DatabaseMigration::Models::UpdateObjectStoreBucket.new(
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
),
source:
OCI::DatabaseMigration::Models::OciCliDumpTransferDetails.new(
kind: 'OCI_CLI',
wallet_location: 'EXAMPLE-walletLocation-Value',
oci_home: 'EXAMPLE-ociHome-Value'
),
target:
OCI::DatabaseMigration::Models::OciCliDumpTransferDetails.new(
kind: 'OCI_CLI',
wallet_location: 'EXAMPLE-walletLocation-Value',
oci_home: 'EXAMPLE-ociHome-Value'
),
shared_storage_mount_target_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sharedStorageMountTargetId-Value'
),
initial_load_settings:
OCI::DatabaseMigration::Models::UpdateOracleInitialLoadSettings.new(
job_mode: 'TABLESPACE',
data_pump_parameters:
OCI::DatabaseMigration::Models::UpdateDataPumpParameters.new(
is_cluster: true,
estimate: 'STATISTICS',
table_exists_action: 'SKIP',
exclude_parameters: %w[
INDEX
MATERIALIZED_VIEW
MATERIALIZED_VIEW_LOG
],
import_parallelism_degree: 787,
export_parallelism_degree: 19
),
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'
),
metadata_remaps: [
OCI::DatabaseMigration::Models::MetadataRemap.new(
type: 'DATAFILE',
old_value: 'EXAMPLE-oldValue-Value',
new_value: 'EXAMPLE-newValue-Value'
)
]
),
advisor_settings:
OCI::DatabaseMigration::Models::UpdateOracleAdvisorSettings.new(
is_skip_advisor: false, is_ignore_errors: true
),
hub_details:
OCI::DatabaseMigration::Models::UpdateGoldenGateHubDetails.new(
rest_admin_credentials:
OCI::DatabaseMigration::Models::UpdateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
url: 'EXAMPLE-url-Value',
compute_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-computeId-Value',
vault_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value',
key_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value',
extract:
OCI::DatabaseMigration::Models::UpdateExtract.new(
performance_profile: 'MEDIUM', long_trans_duration: 998
),
replicat:
OCI::DatabaseMigration::Models::UpdateReplicat.new(
performance_profile: 'HIGH'
),
acceptable_lag: 13
),
ggs_details:
OCI::DatabaseMigration::Models::UpdateOracleGgsDeploymentDetails.new(
extract:
OCI::DatabaseMigration::Models::UpdateExtract.new(
performance_profile: 'LOW', long_trans_duration: 872
),
replicat:
OCI::DatabaseMigration::Models::UpdateReplicat.new(
performance_profile: 'HIGH'
),
acceptable_lag: 9
),
advanced_parameters: [
OCI::DatabaseMigration::Models::MigrationParameterDetails.new(
value: 'EXAMPLE-value-Value',
name: 'EXAMPLE-name-Value',
data_type: 'STRING'
)
],
source_container_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceContainerDatabaseConnectionId-Value'
)
)
# Get the data from response
puts "#{update_migration_response.headers}"