# 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
create_migration_response =
database_migration_client.create_migration(
OCI::DatabaseMigration::Models::CreateOracleMigrationDetails.new(
database_combination: 'ORACLE',
compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
type: 'ONLINE',
description: 'EXAMPLE-description-Value',
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_n0wfc' => 'EXAMPLE_VALUE_ahHpbXkFfvXSgtC3u2rT'
},
defined_tags: {
'EXAMPLE_KEY_7CN0w' => { 'EXAMPLE_KEY_LN18h' => 'EXAMPLE--Value' }
},
assessment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-assessmentId-Value',
data_transfer_medium_details:
OCI::DatabaseMigration::Models::CreateOracleNfsDataTransferMediumDetails
.new(
type: 'NFS',
object_storage_bucket:
OCI::DatabaseMigration::Models::CreateObjectStoreBucket.new(
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
),
source:
OCI::DatabaseMigration::Models::CurlTransferDetails.new(
kind: 'CURL', wallet_location: 'EXAMPLE-walletLocation-Value'
),
target:
OCI::DatabaseMigration::Models::CurlTransferDetails.new(
kind: 'CURL', wallet_location: 'EXAMPLE-walletLocation-Value'
),
shared_storage_mount_target_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sharedStorageMountTargetId-Value'
),
initial_load_settings:
OCI::DatabaseMigration::Models::CreateOracleInitialLoadSettings.new(
data_pump_parameters:
OCI::DatabaseMigration::Models::CreateDataPumpParameters.new(
is_cluster: false,
estimate: 'BLOCKS',
table_exists_action: 'TRUNCATE',
exclude_parameters: %w[
INDEX
MATERIALIZED_VIEW
MATERIALIZED_VIEW_LOG
],
import_parallelism_degree: 37,
export_parallelism_degree: 121
),
tablespace_details:
OCI::DatabaseMigration::Models::CreateNonADBRemapTablespaceDetails
.new(
target_type: 'NON_ADB_REMAP',
remap_target: 'EXAMPLE-remapTarget-Value'
),
export_directory_object:
OCI::DatabaseMigration::Models::CreateDirectoryObject.new(
name: 'EXAMPLE-name-Value', path: 'EXAMPLE-path-Value'
),
import_directory_object:
OCI::DatabaseMigration::Models::CreateDirectoryObject.new(
name: 'EXAMPLE-name-Value', path: 'EXAMPLE-path-Value'
),
job_mode: 'SCHEMA',
metadata_remaps: [
OCI::DatabaseMigration::Models::MetadataRemap.new(
type: 'TABLESPACE',
old_value: 'EXAMPLE-oldValue-Value',
new_value: 'EXAMPLE-newValue-Value'
)
]
),
advisor_settings:
OCI::DatabaseMigration::Models::CreateOracleAdvisorSettings.new(
is_skip_advisor: true, is_ignore_errors: false
),
hub_details:
OCI::DatabaseMigration::Models::CreateGoldenGateHubDetails.new(
rest_admin_credentials:
OCI::DatabaseMigration::Models::CreateAdminCredentials.new(
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value'
),
url: 'EXAMPLE-url-Value',
vault_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value',
key_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-keyId-Value',
compute_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-computeId-Value',
extract:
OCI::DatabaseMigration::Models::CreateExtract.new(
performance_profile: 'LOW', long_trans_duration: 582
),
replicat:
OCI::DatabaseMigration::Models::CreateReplicat.new(
performance_profile: 'HIGH'
),
acceptable_lag: 4
),
ggs_details:
OCI::DatabaseMigration::Models::CreateOracleGgsDeploymentDetails.new(
extract:
OCI::DatabaseMigration::Models::CreateExtract.new(
performance_profile: 'HIGH', long_trans_duration: 412
),
replicat:
OCI::DatabaseMigration::Models::CreateReplicat.new(
performance_profile: 'LOW'
),
acceptable_lag: 16
),
advanced_parameters: [
OCI::DatabaseMigration::Models::MigrationParameterDetails.new(
value: 'EXAMPLE-value-Value',
name: 'EXAMPLE-name-Value',
data_type: 'BOOLEAN'
)
],
source_container_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceContainerDatabaseConnectionId-Value',
source_standby_database_connection_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-sourceStandbyDatabaseConnectionId-Value',
exclude_objects: [
OCI::DatabaseMigration::Models::OracleDatabaseObject.new(
owner: 'EXAMPLE-owner-Value',
object_name: 'EXAMPLE-objectName-Value',
type: 'EXAMPLE-type-Value',
is_omit_excluded_table_from_replication: true
)
],
include_objects: [
OCI::DatabaseMigration::Models::OracleDatabaseObject.new(
owner: 'EXAMPLE-owner-Value',
object_name: 'EXAMPLE-objectName-Value',
type: 'EXAMPLE-type-Value',
is_omit_excluded_table_from_replication: false
)
],
bulk_include_exclude_data: 'EXAMPLE-bulkIncludeExcludeData-Value'
)
)
# Get the data from response
puts "#{create_migration_response.data}"