Class: Aws::DatabaseMigrationService::Types::OracleSettings

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb

Overview

Note:

When making an API call, you may pass OracleSettings data as a hash:

{
  add_supplemental_logging: false,
  archived_log_dest_id: 1,
  additional_archived_log_dest_id: 1,
  allow_select_nested_tables: false,
  parallel_asm_read_threads: 1,
  read_ahead_blocks: 1,
  access_alternate_directly: false,
  use_alternate_folder_for_online: false,
  oracle_path_prefix: "String",
  use_path_prefix: "String",
  replace_path_prefix: false,
  enable_homogenous_tablespace: false,
  direct_path_no_log: false,
  archived_logs_only: false,
  asm_password: "SecretString",
  asm_server: "String",
  asm_user: "String",
  char_length_semantics: "default", # accepts default, char, byte
  database_name: "String",
  direct_path_parallel_load: false,
  fail_tasks_on_lob_truncation: false,
  number_datatype_scale: 1,
  password: "SecretString",
  port: 1,
  read_table_space_name: false,
  retry_interval: 1,
  security_db_encryption: "SecretString",
  security_db_encryption_name: "String",
  server_name: "String",
  username: "String",
}

Provides information that defines an Oracle endpoint.

Constant Summary collapse

SENSITIVE =
[:asm_password, :password, :security_db_encryption]

Instance Attribute Summary collapse

Instance Attribute Details

#access_alternate_directlyBoolean

Set this attribute to false in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source. This tells the DMS instance to not access redo logs through any specified path prefix replacement using direct file access.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#add_supplemental_loggingBoolean

Set this attribute to set up table-level supplemental logging for the Oracle database. This attribute enables PRIMARY KEY supplemental logging on all tables selected for a migration task.

If you use this option, you still need to enable database-level supplemental logging.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#additional_archived_log_dest_idInteger

Set this attribute with archivedLogDestId in a primary/ standby setup. This attribute is useful in the case of a switchover. In this case, AWS DMS needs to know which destination to get archive redo logs from to read changes. This need arises because the previous primary instance is now a standby instance after switchover.

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#allow_select_nested_tablesBoolean

Set this attribute to true to enable replication of Oracle tables containing columns that are nested tables or defined types.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#archived_log_dest_idInteger

Specifies the destination of the archived redo logs. The value should be the same as the DEST_ID number in the v$archived_log table. When working with multiple log destinations (DEST_ID), we recommend that you to specify an archived redo logs location identifier. Doing this improves performance by ensuring that the correct logs are accessed from the outset.

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#archived_logs_onlyBoolean

When this field is set to Y, AWS DMS only accesses the archived redo logs. If the archived redo logs are stored on Oracle ASM only, the AWS DMS user account needs to be granted ASM privileges.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#asm_passwordString

For an Oracle source endpoint, your Oracle Automatic Storage Management (ASM) password. You can set this value from the asm_user_password value. You set this value as part of the comma-separated value that you set to the Password request parameter when you create the endpoint to access transaction logs using Binary Reader. For more information, see Configuration for change data capture (CDC) on an Oracle source database.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#asm_serverString

For an Oracle source endpoint, your ASM server address. You can set this value from the asm_server value. You set asm_server as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#asm_userString

For an Oracle source endpoint, your ASM user name. You can set this value from the asm_user value. You set asm_user as part of the extra connection attribute string to access an Oracle server with Binary Reader that uses ASM. For more information, see Configuration for change data capture (CDC) on an Oracle source database.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#char_length_semanticsString

Specifies whether the length of a character column is in bytes or in characters. To indicate that the character column length is in characters, set this attribute to CHAR. Otherwise, the character column length is in bytes.

Example: charLengthSemantics=CHAR;

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#database_nameString

Database name for the endpoint.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#direct_path_no_logBoolean

When set to true, this attribute helps to increase the commit rate on the Oracle target database by writing directly to tables and not writing a trail to database logs.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#direct_path_parallel_loadBoolean

When set to true, this attribute specifies a parallel load when useDirectPathFullLoad is set to Y. This attribute also only applies when you use the AWS DMS parallel load feature. Note that the target table cannot have any constraints or indexes.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#enable_homogenous_tablespaceBoolean

Set this attribute to enable homogenous tablespace replication and create existing tables or indexes under the same tablespace on the target.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#fail_tasks_on_lob_truncationBoolean

When set to true, this attribute causes a task to fail if the actual size of an LOB column is greater than the specified LobMaxSize.

If a task is set to limited LOB mode and this option is set to true, the task fails instead of truncating the LOB data.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#number_datatype_scaleInteger

Specifies the number scale. You can select a scale up to 38, or you can select FLOAT. By default, the NUMBER data type is converted to precision 38, scale 10.

Example: numberDataTypeScale=12

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#oracle_path_prefixString

Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source. This value specifies the default Oracle root used to access the redo logs.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#parallel_asm_read_threadsInteger

Set this attribute to change the number of threads that DMS configures to perform a Change Data Capture (CDC) load using Oracle Automatic Storage Management (ASM). You can specify an integer value between 2 (the default) and 8 (the maximum). Use this attribute together with the readAheadBlocks attribute.

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#passwordString

Endpoint connection password.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#portInteger

Endpoint TCP port.

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#read_ahead_blocksInteger

Set this attribute to change the number of read-ahead blocks that DMS configures to perform a Change Data Capture (CDC) load using Oracle Automatic Storage Management (ASM). You can specify an integer value between 1000 (the default) and 200,000 (the maximum).

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#read_table_space_nameBoolean

When set to true, this attribute supports tablespace replication.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#replace_path_prefixBoolean

Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source. This setting tells DMS instance to replace the default Oracle root with the specified usePathPrefix setting to access the redo logs.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#retry_intervalInteger

Specifies the number of seconds that the system waits before resending a query.

Example: retryInterval=6;

Returns:

  • (Integer)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#security_db_encryptionString

For an Oracle source endpoint, the transparent data encryption (TDE) password required by AWM DMS to access Oracle redo logs encrypted by TDE using Binary Reader. It is also the TDE_Password part of the comma-separated value you set to the Password request parameter when you create the endpoint. The SecurityDbEncryptian setting is related to this SecurityDbEncryptionName setting. For more information, see Supported encryption methods for using Oracle as a source for AWS DMS in the AWS Database Migration Service User Guide.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#security_db_encryption_nameString

For an Oracle source endpoint, the name of a key used for the transparent data encryption (TDE) of the columns and tablespaces in an Oracle source database that is encrypted using TDE. The key value is the value of the SecurityDbEncryption setting. For more information on setting the key name value of SecurityDbEncryptionName, see the information and example for setting the securityDbEncryptionName extra connection attribute in Supported encryption methods for using Oracle as a source for AWS DMS in the AWS Database Migration Service User Guide.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#server_nameString

Fully qualified domain name of the endpoint.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#use_alternate_folder_for_onlineBoolean

Set this attribute to true in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source. This tells the DMS instance to use any specified prefix replacement to access all online redo logs.

Returns:

  • (Boolean)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#use_path_prefixString

Set this string attribute to the required value in order to use the Binary Reader to capture change data for an Amazon RDS for Oracle as the source. This value specifies the path prefix used to replace the default Oracle root to access the redo logs.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end

#usernameString

Endpoint connection user name.

Returns:

  • (String)


5806
5807
5808
5809
5810
5811
5812
5813
5814
5815
5816
5817
5818
5819
5820
5821
5822
5823
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 5806

class OracleSettings < Struct.new(
  :add_supplemental_logging,
  :archived_log_dest_id,
  :additional_archived_log_dest_id,
  :allow_select_nested_tables,
  :parallel_asm_read_threads,
  :read_ahead_blocks,
  :access_alternate_directly,
  :use_alternate_folder_for_online,
  :oracle_path_prefix,
  :use_path_prefix,
  :replace_path_prefix,
  :enable_homogenous_tablespace,
  :direct_path_no_log,
  :archived_logs_only,
  :asm_password,
  :asm_server,
  :asm_user,
  :char_length_semantics,
  :database_name,
  :direct_path_parallel_load,
  :fail_tasks_on_lob_truncation,
  :number_datatype_scale,
  :password,
  :port,
  :read_table_space_name,
  :retry_interval,
  :security_db_encryption,
  :security_db_encryption_name,
  :server_name,
  :username)
  SENSITIVE = [:asm_password, :password, :security_db_encryption]
  include Aws::Structure
end