OracleSettings class
Provides information that defines an Oracle endpoint.
Constructors
- OracleSettings({bool? accessAlternateDirectly, bool? addSupplementalLogging, int? additionalArchivedLogDestId, bool? allowSelectNestedTables, int? archivedLogDestId, bool? archivedLogsOnly, String? asmPassword, String? asmServer, String? asmUser, CharLengthSemantics? charLengthSemantics, String? databaseName, bool? directPathNoLog, bool? directPathParallelLoad, bool? enableHomogenousTablespace, bool? failTasksOnLobTruncation, int? numberDatatypeScale, String? oraclePathPrefix, int? parallelAsmReadThreads, String? password, int? port, int? readAheadBlocks, bool? readTableSpaceName, bool? replacePathPrefix, int? retryInterval, String? secretsManagerAccessRoleArn, String? secretsManagerOracleAsmAccessRoleArn, String? secretsManagerOracleAsmSecretId, String? secretsManagerSecretId, String? securityDbEncryption, String? securityDbEncryptionName, String? serverName, bool? useAlternateFolderForOnline, String? usePathPrefix, String? username})
-
OracleSettings.fromJson(Map<
String, dynamic> json) -
factory
Properties
- accessAlternateDirectly → bool?
-
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.final - additionalArchivedLogDestId → int?
-
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.final - addSupplementalLogging → bool?
-
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.
final
- allowSelectNestedTables → bool?
-
Set this attribute to
true
to enable replication of Oracle tables containing columns that are nested tables or defined types.final - archivedLogDestId → int?
-
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.
final
- archivedLogsOnly → bool?
-
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.final - asmPassword → String?
-
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 thePassword
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.final - asmServer → String?
-
For an Oracle source endpoint, your ASM server address. You can set this
value from the
asm_server
value. You setasm_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.final - asmUser → String?
-
For an Oracle source endpoint, your ASM user name. You can set this value
from the
asm_user
value. You setasm_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.final - charLengthSemantics → CharLengthSemantics?
-
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.final - databaseName → String?
-
Database name for the endpoint.
final
- directPathNoLog → bool?
-
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.final - directPathParallelLoad → bool?
-
When set to
true
, this attribute specifies a parallel load whenuseDirectPathFullLoad
is set toY
. 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.final - enableHomogenousTablespace → bool?
-
Set this attribute to enable homogenous tablespace replication and create
existing tables or indexes under the same tablespace on the target.
final
- failTasksOnLobTruncation → bool?
-
When set to
true
, this attribute causes a task to fail if the actual size of an LOB column is greater than the specifiedLobMaxSize
.final - hashCode → int
-
The hash code for this object.
no setterinherited
- numberDatatypeScale → int?
-
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.
final
- oraclePathPrefix → String?
-
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.
final
- parallelAsmReadThreads → int?
-
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.final - password → String?
-
Endpoint connection password.
final
- port → int?
-
Endpoint TCP port.
final
- readAheadBlocks → int?
-
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).
final
- readTableSpaceName → bool?
-
When set to
true
, this attribute supports tablespace replication.final - replacePathPrefix → bool?
-
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.final - retryInterval → int?
-
Specifies the number of seconds that the system waits before resending a
query.
final
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- secretsManagerAccessRoleArn → String?
-
The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS
as the trusted entity and grants the required permissions to access the
value in
SecretsManagerSecret
.SecretsManagerSecret
has the value of the AWS Secrets Manager secret that allows access to the Oracle endpoint.final - secretsManagerOracleAsmAccessRoleArn → String?
-
Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
The full ARN of the IAM role that specifies AWS DMS as the trusted entity
and grants the required permissions to access the
SecretsManagerOracleAsmSecret
. ThisSecretsManagerOracleAsmSecret
has the secret value that allows access to the Oracle ASM of the endpoint.final - secretsManagerOracleAsmSecretId → String?
-
Required only if your Oracle endpoint uses Advanced Storage Manager (ASM).
The full ARN, partial ARN, or friendly name of the
SecretsManagerOracleAsmSecret
that contains the Oracle ASM connection details for the Oracle endpoint.final - secretsManagerSecretId → String?
-
The full ARN, partial ARN, or friendly name of the
SecretsManagerSecret
that contains the Oracle endpoint connection details.final - securityDbEncryption → String?
-
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 thePassword
request parameter when you create the endpoint. TheSecurityDbEncryptian
setting is related to thisSecurityDbEncryptionName
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.final - securityDbEncryptionName → String?
-
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 ofSecurityDbEncryptionName
, see the information and example for setting thesecurityDbEncryptionName
extra connection attribute in Supported encryption methods for using Oracle as a source for AWS DMS in the AWS Database Migration Service User Guide.final - serverName → String?
-
Fully qualified domain name of the endpoint.
final
- useAlternateFolderForOnline → bool?
-
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.final - usePathPrefix → String?
-
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.
final
- username → String?
-
Endpoint connection user name.
final
Methods
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
toJson(
) → Map< String, dynamic> -
toString(
) → String -
A string representation of this object.
inherited
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited