MDAA TS Docs
    Preparing search index...

    Interface OracleSettingsProperty

    Provides information that defines an Oracle endpoint. Modified from the equivalent L1 Construct to prevent use of plaintext credentials and enforce use of KMS encryption. This information includes the output format of records applied to the endpoint and details of transaction and control table data information. For information about other available settings, see Extra connection attributes when using Oracle as a source for AWS DMS and Extra connection attributes when using Oracle as a target for AWS DMS in the AWS Database Migration Service User Guide .

    See: http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-oraclesettings.html

    interface OracleSettingsProperty {
        accessAlternateDirectly?: boolean;
        additionalArchivedLogDestId?: number;
        addSupplementalLogging?: boolean;
        allowSelectNestedTables?: boolean;
        archivedLogDestId?: number;
        archivedLogsOnly?: boolean;
        asmServer?: string;
        charLengthSemantics?: string;
        directPathNoLog?: boolean;
        directPathParallelLoad?: boolean;
        enableHomogenousTablespace?: boolean;
        extraArchivedLogDestIds?: number[];
        failTasksOnLobTruncation?: boolean;
        numberDatatypeScale?: number;
        oraclePathPrefix?: string;
        parallelAsmReadThreads?: number;
        readAheadBlocks?: number;
        readTableSpaceName?: boolean;
        replacePathPrefix?: boolean;
        retryInterval?: number;
        secretsManagerAccessRoleArn?: string;
        secretsManagerOracleAsmAccessRoleArn?: string;
        secretsManagerOracleAsmSecretArn?: string;
        secretsManagerSecretArn: string;
        secretsManagerSecretKMSArn?: string;
        spatialDataOptionToGeoJsonFunctionName?: string;
        standbyDelayTime?: number;
        useAlternateFolderForOnline?: boolean;
        useBFile?: boolean;
        useDirectPathFullLoad?: boolean;
        useLogminerReader?: boolean;
        usePathPrefix?: string;
    }
    Index

    Properties

    accessAlternateDirectly? additionalArchivedLogDestId? addSupplementalLogging? allowSelectNestedTables? archivedLogDestId? archivedLogsOnly? asmServer? charLengthSemantics? directPathNoLog? directPathParallelLoad? enableHomogenousTablespace? extraArchivedLogDestIds? failTasksOnLobTruncation? numberDatatypeScale? oraclePathPrefix? parallelAsmReadThreads? readAheadBlocks? readTableSpaceName? replacePathPrefix? retryInterval? secretsManagerAccessRoleArn? secretsManagerOracleAsmAccessRoleArn? secretsManagerOracleAsmSecretArn? secretsManagerSecretArn secretsManagerSecretKMSArn? spatialDataOptionToGeoJsonFunctionName? standbyDelayTime? useAlternateFolderForOnline? useBFile? useDirectPathFullLoad? useLogminerReader? usePathPrefix?

    Properties

    accessAlternateDirectly?: boolean

    Flag to disable Binary Reader access to redo logs through direct file access for Oracle RDS sources

    additionalArchivedLogDestId?: number

    Additional archived log destination ID for Oracle primary/standby switchover scenarios

    addSupplementalLogging?: boolean

    Flag to enable table-level supplemental logging for Oracle database migration tasks

    allowSelectNestedTables?: boolean

    Flag to enable replication of Oracle tables with nested tables or defined types for complex

    archivedLogDestId?: number

    Archived redo log destination ID for Oracle change data capture configuration

    archivedLogsOnly?: boolean

    Flag to restrict DMS access to archived redo logs only for Oracle replication

    asmServer?: string

    ASM server address for Oracle source endpoint Binary Reader configuration

    charLengthSemantics?: string

    Character length semantics specification for Oracle character column interpretation

    directPathNoLog?: boolean

    Flag to enable direct path loading without database logging for Oracle target performance optimization

    directPathParallelLoad?: boolean

    Flag to enable parallel loading when direct path full load is active for Oracle target

    enableHomogenousTablespace?: boolean

    Flag to enable homogeneous tablespace replication for Oracle target database consistency

    extraArchivedLogDestIds?: number[]

    Array of additional archived log destination IDs for Oracle Data Guard switchover scenarios

    failTasksOnLobTruncation?: boolean

    Flag to cause task failure when LOB column size exceeds specified LobMaxSize limit

    numberDatatypeScale?: number

    Number data type scale specification for Oracle NUMBER data type conversion precision

    oraclePathPrefix?: string

    Oracle path prefix for Binary Reader redo log access configuration

    parallelAsmReadThreads?: number

    Number of parallel ASM read threads for Oracle change data capture performance optimization

    readAheadBlocks?: number

    Number of read-ahead blocks for Oracle ASM change data capture performance optimization

    readTableSpaceName?: boolean

    Flag to enable tablespace name reading for Oracle tablespace replication support

    replacePathPrefix?: boolean

    Flag to enable path prefix replacement for Binary Reader redo log access

    retryInterval?: number

    Retry interval in seconds for Oracle connection query retry operations

    secretsManagerAccessRoleArn?: string

    IAM role ARN for AWS Secrets Manager access to Oracle endpoint credentials

    secretsManagerOracleAsmAccessRoleArn?: string

    IAM role ARN for AWS Secrets Manager access to Oracle ASM credentials when using Advanced Storage Manager

    secretsManagerOracleAsmSecretArn?: string

    Secrets Manager secret ARN containing Oracle ASM connection details for Advanced Storage Manager endpoints

    secretsManagerSecretArn: string

    Secrets Manager secret ARN containing Oracle endpoint connection details for secure credential management

    secretsManagerSecretKMSArn?: string

    KMS key ARN for encrypting Oracle endpoint credentials secret in Secrets Manager

    spatialDataOptionToGeoJsonFunctionName?: string

    Custom function name for converting Oracle SDO_GEOMETRY to GEOJSON format during spatial data migration

    standbyDelayTime?: number

    Standby delay time in minutes for Oracle Active Data Guard standby database synchronization

    useAlternateFolderForOnline?: boolean

    Flag to enable alternate folder usage for online redo logs with Binary Reader for Oracle RDS sources

    useBFile?: boolean

    Flag to enable Binary Reader utility for Oracle change data capture operations

    useDirectPathFullLoad?: boolean

    Flag to enable direct path full load for Oracle target database performance optimization

    useLogminerReader?: boolean

    Flag to enable Oracle LogMiner utility for change data capture operations (default method)

    usePathPrefix?: string

    Path prefix for Binary Reader redo log access replacement in Oracle RDS sources

    Settings

    Member Visibility

    On This Page

    Properties