E Zero Downtime Migration Logical Migration Response File Parameters Reference

Zero Downtime Migration response file parameters supported for logical migrations.

DATA_TRANSFER_MEDIUM

Specifies how data will be transferred from the source database system to the target database system.

See also Configuring the Transfer Medium and Specifying Transfer Nodes

Property	Description
Syntax	DATA_TRANSFER_MEDIUM = {OSS | NFS | DBLINK | COPY | AMAZON3}
Default value	OSS
Range of values	OSS - Object Storage Service NFS - Network File System DBLINK - Direct transfer of data over a database link COPY - secure copy (for user-managed targets only) AMAZON3 - Amazon Simple Storage Service (Amazon S3) bucket (only supported when SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON
Required	Yes
Modifiable on Resume	No

DATAPUMPSETTINGS_CREATEAUTHTOKEN

Indicates whether to create a new OCI Auth Token.

If you are not using a network database link for Data Pump Import, an OCI Auth Token is created for the specified OCI user to import Data Pump dump files from the Object Storage into an Autonomous Database.

To reuse an existing Auth Token, set this property to FALSE.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_CREATEAUTHTOKEN ={TRUE | FALSE}
Default value	FALSE
Range of values	TRUE - Creates an OCI Auth Token for the specified OCI user FALSE - Does not create an OCI Auth Token.
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATABASELINKDETAILS_NAME

Specifies the name of the database link from the OCI database to the on-premise database.

Zero Downtime Migration creates the database link if the link does not already exist.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

The DATAPUMPSETTINGS_DATABASELINKDETAILS_* parameters are optional details for creating a network database link from OCI database to the on-premise database.

Property	Description
Syntax	DATAPUMPSETTINGS_DATABASELINKDETAILS_NAME = db_link_name
Default value	There is no default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_BUCKETNAME

Specifies the OCI Object Storage bucket.

The DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_* parameters are used with Autonomous Database migration targets. These parameters settings specify the OCI Object Storage details used to store the wallet containing the certificate for on-premise database to create a database link from the Autonomous Database to the on-premise database using TLS.

Not required for a TCP connection from Autonomous Database to the on-premise database.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_BUCKETNAME = Object Storage bucket name
Default value	There is no default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_NAMESPACENAME

Specifies the Object Storage namespace.

The DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_* parameters are used with Autonomous Database migration targets. These parameters settings specify the OCI Object Storage details used to store the wallet containing the certificate for on-premise database to create a database link from the Autonomous Database to the on-premise database using TLS.

Not required for a TCP connection from Autonomous Database to the on-premise database.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_DATABASELINKDETAILS_WALLETBUCKET_NAMESPACENAME = Object Storage bucket namespace
Default value	There is no default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME

In lieu of a network database link, the OCI Object Storage bucket specified in DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME is used to store Data Pump dump files for migrating to an Autonomous Database.

DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME is one of the optional settings for logical migrations using Data Pump.

Use with DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME = Name of the Object Storage bucket
Default value	There is no default value
Range of values	Enter the storage bucket name
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME

In lieu of a network database link, the OCI Object Storage bucket specified with DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME is used to store Data Pump dump files for migrating to an Autonomous Database.

DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME is one of the optional settings for logical migrations using Data Pump.

Use with DATAPUMPSETTINGS_DATABUCKET_BUCKETNAME

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_DATABUCKET_NAMESPACENAME = Object Storage namespace
Default value	There is no default value
Range of values	Enter the storage bucket namespace
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_ESTIMATEBYSTATISTICS

Specifies the STATISTICS method for Data Pump dump size estimation.

Zero Downtime Migration estimates the Data Pump dump size using the BLOCKS or STATISTICS methods. You are expected to apply discretion in arriving at the FILESYSTEM space required for the dump path, considering other factors that affect the actual dump size expected. The estimated dump size and actual size varies based on the data compression applied on the data in the database.

• If data is compressed, then it would be the same as that of the reported ESTIMATE
• If data is uncompressed, then Zero Downtime Migration exports with COMPRESSION set as MEDIUM and the resulting dump would be ~50% of estimate
• There is deviation in dump size expected between data having HCC vs. Advanced compression modes

Note that by default, Zero Downtime Migration performs estimation using the BLOCKS method as part of the precheck and as part of the actual migration part of phase ZDM_DATAPUMP_ESTIMATE_SRC.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_ESTIMATEBYSTATISTICS = [TRUE | FALSE]
Default value	FALSE
Valid values	TRUE enables this parameter FALSE disables this parameter
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_ESTIMATE_SRC phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST

Specifies a comma separated list of object types to exclude.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST = object_type_list
Default value	There is no default
Valid values	A comma separated list of object types
Required	No
Modifiable on Resume	No

Example

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXCLUDETYPELIST=cluster,dblink,comment

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE

Specifies the maximum number of worker processes that can be used for a Data Pump Import job.

For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_EXPORTPARALLELISMDEGREE = integer
Default value	There is no default value
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE

Specifies the maximum number of worker processes that can be used for a Data Pump Import job.

For migration to an Autonomous Database target, Zero Downtime Migration automatically queries its CPU core count and sets this parameter.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_IMPORTPARALLELISMDEGREE = integer
Default value	There is no default value
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER

Specifies whether all Data Pump workers are started on the current instance or on instances usable by the job.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_NOCLUSTER = [TRUE | FALSE]
Default value	FALSE
Valid values	TRUE all Data Pump workers are started on the current instance FALSE Data Pump workers are started on instances usable by the job
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_RETAININDEX

Specifies whether to retain the index.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_RETAININDEX = [TRUE | FALSE]
Default value	FALSE
Valid values	TRUE retains the index FALSE does not retain the index
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED, or until ZDM_DATAPUMP_IMPORT_TGT phase when using DATA_TRANSFER_MEDIUM=DBLINK.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_SKIPCURRENT

Specifies whether actions that were "in progress" on a previous execution of the job are skipped when the job restarts.

This mechanism allows you to skip actions that trigger fatal bugs and cause the premature termination of a job. Multiple actions can be skipped on a restart. The log file identifies which actions are skipped.

The skip is only honored for Import jobs.

If a domain index was being processed, all pieces of the domain index are skipped, even if the error only occurred in a sub-component of the domain index.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_SKIPCURRENT = [TRUE | FALSE]
Default value	FALSE
Valid values	TRUE enables this parameter FALSE disables this parameter
Required	No
Modifiable in Resume	Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION

Specifies the action to be performed when data is loaded into a preexisting table.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_TABLEEXISTSACTION = [SKIP | TRUNCATE | REPLACE | APPEND]
Default value	SKIP
Range of values	SKIP - the preexisting table is left unchanged. TRUNCATE - rows are removed from a preexisting table before inserting rows from the Import. Note that if TRUNCATE is specified on tables referenced by foreign key constraints, the TRUNCATE will be modified into a REPLACE. REPLACE - preexisting tables are replaced with new definitions. Before creating the new table, the old table is dropped. APPEND - new rows are added to the existing rows in the table See TABLE_EXISTS_ACTION entry in Table 48-25 "Valid Options for the name Parameter in the SET_PARAMETER Procedure" in SET_PARAMETER Procedures
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED.

DATAPUMPSETTINGS_DATAPUMPPARAMETERS_USERMETADATA

For EXPORT and Network IMPORT, if set to a nonzero value for schema-mode operations, specifies that the metadata to re-create the user's schemas should also be part of the operation.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

DATAPUMPSETTINGS_DATAPUMPPARAMETER_* are optional parameters for Data Pump Export and Import. See SET_PARAMETER Procedures for more information.

Property	Description
Syntax	DATAPUMPSETTINGS_DATAPUMPPARAMETERS_USERMETADATA = integer
Default value	There is no default value
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC is COMPLETED, or until ZDM_DATAPUMP_IMPORT_TGT phase when using DATA_TRANSFER_MEDIUM=DBLINK.

DATAPUMPSETTINGS_DELETEDUMPSINOSS

Indicates whether to retain dump files which are uploaded to Object Storage as part of the migration.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_DELETEDUMPSINOSS = {TRUE|FALSE}
Default value	TRUE
Range of values	TRUE = delete dumps FALSE = retain dumps
Required	No
Modifiable on Resume	Until ZDM_POST_DATAPUMP_TGT phase is COMPLETED.

DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME

Specifies the object name of a directory on server file system of an on-premises database.

In lieu of a network database link, a directory on the server file system of an on-premises database, specified with the DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_* properties is used to store Data Pump Export dump files.

Zero Downtime Migration creates this object if it does not already exist

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_NAME = Name
Default value	There is no default value
Range of values	Name of directory object in the database.
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH

Specifies the object path of a directory on server file system of an on-premises database.

In lieu of a network database link, a directory on the server file system of an on-premises database, specified with the DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_* properties is used to store Data Pump Export dump files.

Zero Downtime Migration creates this object if it does not already exist

Note:

For Oracle Database 19c and later releases, the UTL_FILE_DIR initialization parameter is desupported, which means symbolic links for Data Pump directories are not supported.

If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.

See How Does Oracle Data Pump Move Data? for more information.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_EXPORTDIRECTORYOBJECT_PATH = Path
Default value	There is no default value
Range of values	Absolute path of directory on database server
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_SRC phase is COMPLETED.

DATAPUMPSETTINGS_FIXINVALIDOBJECTS

Specifies whether invalid objects are recompiled in the database as part of the migration job.

Migration can result in invalid schema objects. Typically, invalid objects fix themselves as they are accessed or run. However, Oracle recommends that invalid objects are recompiled in the database as part of the Zero Downtime Migration migration job so that issues with invalid objects, and any required dependencies, are resolved before users encounter these invalid objects.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_FIXINVALIDOBJECTS = {TRUE | FALSE}
Default value	FALSE
Range of values	TRUE = fix invalid objects FALSE = do not fix invalid objects
Required	No
Modifiable on Resume	Until ZDM_POST_DATAPUMP_TGT phase is COMPLETED.

DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME

Specifies the name of an import directory object.

In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.

Zero Downtime Migration creates this object if it does not already exist.

For Autonomous Database migration targets, the DATA_PUMP_DIR object will already exist.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_NAME = Name of the directory object
Default value	There is no default value
Range of values	Name of directory object in database
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phase is COMPLETED.

DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH

Specifies the path of an import directory object.

In lieu of a network database link, a directory on the server file system of OCI database is used to store Data Pump dump files.

Zero Downtime Migration creates this object if it does not already exist.

For Autonomous Database migration targets, the DATA_PUMP_DIR object will already exist.

Note:

For Oracle Database 19c and later releases, the UTL_FILE_DIR initialization parameter is desupported, which means symbolic links for Data Pump directories are not supported.

If you attempt to use an affected feature configured with symbolic links, then you encounter ORA-29283: invalid file operation: path traverses a symlink. Oracle recommends that you instead use directory objects in place of symbolic links.

See How Does Oracle Data Pump Move Data? for more information.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_IMPORTDIRECTORYOBJECT_PATH = Path of the directory object
Default value	There is no default value
Range of values	Absolute path of directory on database server
Required	No
Modifiable on Resume	Until ZDM_VALIDATE_DATAPUMP_SETTINGS_TGT phase is COMPLETED.

DATAPUMPSETTINGS_JOBMODE

Specifies the Data Pump export mode.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_JOBMODE = jobModeValue
Default value	SCHEMA
Range of values	FULL performs a full database export. SCHEMA (default) lets you specify a set of schemas to export. TABLE lets you specify a set of tables to export. In this mode, Zero Downtime Migration precreates the target schema before Data Pump import. TABLESPACE lets you specify a set of tablespaces to export. In this mode, Zero Downtime Migration precreates the target schema before Data Pump import. TRANSPORTABLE is not supported by Zero Downtime Migration. See Oracle Data Pump Export Modes for more information.
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_METADATAFILTERS-LIST_ELEMENT_NUMBER

Defines the name, the object type, and the value of the filter for the Data Pump METADATA_FILTER property.

To add multiple filters, increment the integer appended to the parameter name, as shown in the examples below.

DATAPUMPSETTINGS_METADATAFILTERS-1=name:nameValue1st, objectType:objectTypeValue1st, value:valueValue1st
DATAPUMPSETTINGS_METADATAFILTERS-2=name:nameValue2nd, objectType:objectTypeValue2nd, value:valueValue2nd

To exclude select SCHEMA Objects for FULL mode:

DATAPUMPSETTINGS_METADATAFILTERS-1=name:NAME_EXPR,value:'NOT IN(' 'SYSMAN' ')',objectType:SCHEMA
DATAPUMPSETTINGS_METADATAFILTERS-2=name:NAME_EXPR,value:'NOT IN(' 'SH' ')',objectType:SCHEMA

Note that the SCHEMA name SYSMAN is surrounded by two single quotes and not a double quote.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_METADATAFILTERS-LIST_ELEMENT_NUMBER = name:nameValue, objectType:objectTypeValue, value:valueValue
Default value	There is no default value
Range of values	An entry specifying the name, type, and value is expected, as shown in the examples above.
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_METADATAREMAPS-LIST_ELEMENT_NUMBER

Defines remapping to be applied to objects as they are processed.

To add multiple remappings, increment the integer appended to the parameter name, as shown in the examples below.

DATAPUMPSETTINGS_METADATAREMAPS-1=type:typeValue1st, oldValue:oldValueValue1st, newValue:newValueValue1st
DATAPUMPSETTINGS_METADATAREMAPS-2=type:typeValue2nd, oldValue:oldValueValue2nd, newValue:newValueValue2nd

See METADATA_REMAP Procedure for more information.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_METADATAREMAPS-LIST_ELEMENT_NUMBER = newValue:newValueValue, oldValue:oldValueValue, type:typeValue
Default value	There is no default value
Range of values	An entry specifying the new value, old value and type is expected, as shown in the examples above.
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED, or until ZDM_DATAPUMP_IMPORT_TGT phase when using DATA_TRANSFER_MEDIUM=DBLINK

DATAPUMPSETTINGS_METADATATRANSFORMS-LIST_ELEMENT_NUMBER

Defines the name, the object type, and the value for the Data Pump METADATA_TRANSFORM property.

To add multiple filters, increment the integer appended to the parameter name, as shown in the examples below.

DATAPUMPSETTINGS_METADATATRANSFORMS-1=name:nameValue1st, objectType:objectTypeValue1st, value:valueValue1st
DATAPUMPSETTINGS_METADATATRANSFORMS-2=name:nameValue2nd, objectType:objectTypeValue2nd, value:valueValue2nd

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_METADATATRANSFORMS-LIST_ELEMENT_NUMBER = name:nameValue, objectType:objectTypeValue, value:valueValue
Default value	There is no default value
Range of values	An entry specifying the name, type, and value is expected, as shown in the examples above.
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_MONITORINTERVALMINUTES

Specifies the Data Pump monitor interval in minutes. This setting is optional.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_MONITORINTERVALMINUTES = number
Default value	10
Range of values	An integer value is expected
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE

Sets TRANSFORM=OMIT_ENCRYPTION_CLAUSE, which directs Data Pump to suppress any encryption clauses associated with objects using encrypted columns.

This parameter is valid for targets on Oracle Database 19c and later releases.

OMIT_ENCRYPTION_CLAUSE applies to materialized view, table, and tablespace objects, and enables objects which were using encrypted columns in the source to get created in a target database environment where encryption attributes are not supported.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_OMITENCRYPTIONCLAUSE = [TRUE | FALSE]
Default value	TRUE
Valid values	TRUE enables this parameter FALSE disables this parameter
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_SECUREFILELOB

Sets TRANSFORM=LOB_STORAGE:SECUREFILE, which directs Data Pump to transform basic LOBs into securefile LOBs during the Data Pump import.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_SECUREFILELOB = [TRUE | FALSE]
Default value	TRUE
Valid values	TRUE enables this parameter FALSE disables this parameter
Required	No
Modifiable on Resume	No

DATAPUMPSETTINGS_SKIPDEFAULTTRANSFORM

Skips default transform parameters.

Set this property to TRUE to avoid all internal Zero Downtime Migration transform defaults.

Parameter Relationships

The optional DATAPUMPSETTINGS_* parameters let you customize Oracle Data Pump Export and Import jobs.

Property	Description
Syntax	DATAPUMPSETTINGS_SKIPDEFAULTTRANSFORM = [TRUE | FALSE]
Default value	FALSE
Valid values	TRUE enables this parameter FALSE disables this parameter
Required	No
Modifiable on Resume	No

DUMPTRANSFERDETAILS_PARALLELCOUNT

Specifies the maximum number of Export dump files to transfer to Object Storage or remote node in parallel.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property	Description
Syntax	DUMPTRANSFERDETAILS_PARALLELCOUNT = integer
Default value	3
Range of values	This parameter accepts integer values
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_RETRYCOUNT

Specifies the number of times to retry upload or transfer of dump failure.

Intermittent network failures observed during the transfer of Data Pump dumps can mitigated by setting the DUMPTRANSFERDETAILS_RETRYCOUNT parameter.

Parameter Relationships

The DUMPTRANSFERDETAILS parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property	Description
Syntax	DUMPTRANSFERDETAILS_RETRYCOUNT = integer
Default value	3
Range of values	This parameter accepts integer values
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_RSYNCAVAILABLE

Specifies that the transfer dump files are using the Linux rsync utility.

Ensure rsync is installed in both source and target servers. Oracle Exadata does not ship with rsync, refer to MOS Doc ID 1556257.1 for details. ZDM defaults to scp command for transfer.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property	Description
Syntax	DUMPTRANSFERDETAILS_RSYNCAVAILABLE = {TRUE | FALSE
Default value	FALSE
Range of values	TRUE - transfer dump files are using the Linux rsync utility FALSE - not using rsync
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY

Specifies the access key of the Amazon Simple Storage Service (Amazon S3) bucket.

When you set DATA_TRANSFER_MEDIUM=AMAZON3 to migrate an Amazon Web Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you must also set the DUMPTRANSFERDETAILS_S3BUCKET_* parameters.

See Migrating from Amazon Web Services RDS to Oracle Autonomous Database for details.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Property	Description
Syntax	DUMPTRANSFERDETAILS_S3BUCKET_ACCESSKEY = s3_bucket_access_key
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_S3BUCKET_NAME

Specifies the name of the Amazon Simple Storage Service (Amazon S3) bucket.

When you set DATA_TRANSFER_MEDIUM=AMAZON3 to migrate an Amazon Web Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you must also set the DUMPTRANSFERDETAILS_S3BUCKET_* parameters.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Property	Description
Syntax	DUMPTRANSFERDETAILS_S3BUCKET_NAME = s3_bucket_name
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_S3BUCKET_REGION

Specifies the region of the Amazon Simple Storage Service (Amazon S3) bucket.

When you set DATA_TRANSFER_MEDIUM=AMAZON3 to migrate an Amazon Web Services RDS Oracle database to Oracle Autonomous Database using an S3 bucket, you must also set the DUMPTRANSFERDETAILS_S3BUCKET_* parameters.

See Migrating from Amazon Web Services RDS to Oracle Autonomous Database for details.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Property	Description
Syntax	DUMPTRANSFERDETAILS_S3BUCKET_REGION = s3_bucket_region
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_OCIHOME

Specifies the Oracle Cloud OCI-CLI Binary path.

Parameter Relationships

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_OCIHOME = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_PARTSIZEMB

Specifies the part size in MB for chunked transfer.

Parameter Relationships

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_PARTSIZEMB = integer
Default value	128
Range of values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_DUMPDIRPATH

Specifies the absolute path of the directory to copy or upload dump files.

The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node. Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_DUMPDIRPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_HOST

Specifies the dump transfer node host name.

The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node. Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_HOST = host_name
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_SUDOPATH

Specifies the Sudo path on the dump transfer node.

The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node. Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_SUDOPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USER

Specifies the user allowed to execute OCI CLI in the dump transfer node.

The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USER = user
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USERKEY

Specifies the user's authentication key.

The DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using Oracle Cloud OCI-CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node. Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_TRANSFERNODE_USERKEY = user_auth_key
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_SOURCE_USEOCICLI

Indicates that transfer dump files use Oracle Cloud Infrastructure command line interface (CLI).

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_SOURCE_* parameters specify details to upload the Dump files from source node Data Pump dump location to Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_SOURCE_USEOCICLI = {TRUE | FALSE}
Default value	FALSE
Range of values	TRUE or FALSE
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_OCIHOME

Specifies the Oracle Cloud Infrastructure command line interface (CLI) Binary path.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_OCIHOME = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_PARTSIZEMB

Specifies the part size in MB for chunked transfer.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_PARTSIZEMB = integer
Default value	128
Range of values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_DUMPDIRPATH

Specifies the absolute path of the directory to copy or upload dump files.

The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using the OCI CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_DUMPDIRPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_HOST

Specifies the dump transfer node host name.

The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_HOST = host_name
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_SUDOPATH

Specifies the Sudo path on the dump transfer node.

The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_SUDOPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USER

Specifies the user allowed to execute OCI CLI in the dump transfer node.

The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node. Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USER = user
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USERKEY

Specifies the user's authentication key.

The DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_* parameters are configured when you use a standalone server as transfer server.

Transfer dump files using OCI CLI or curl, or copy to or from a node other than the database server.

This option can be leveraged for cases where OCI CLI is installed and configured in a specific node per data center and the node has the Data Pump export or import directory path shared with it. This avoids the requirement of installing OCI CLI on the database node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through Oracle Cloud Infrastructure command line interface (CLI) or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_TRANSFERNODE_USERKEY = user_auth_key
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TARGET_USEOCICLI

Indicates that transfer dump files use Oracle Cloud Infrastructure command line interface (CLI).

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TARGET_* parameters specify details to download the Dump files to the target node Data Pump dump location from Oracle Cloud Object Storage.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TARGET_USEOCICLI = {TRUE | FALSE}
Default value	FALSE
Range of values	TRUE or FALSE
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TRANSFERTARGET_DUMPDIRPATH

Specifies the absolute path of the directory to copy or upload dump files.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TRANSFERTARGET_* parameters specify details for the target node to copy the Dump files from source node Data Pump dump location or transfer node directory path specified. Default target database host.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TRANSFERTARGET_DUMPDIRPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST

DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST specifies the dump transfer node host name.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TRANSFERTARGET_* parameters specify details for the target node to copy the Dump files from source node Data Pump dump location or transfer node directory path specified. Default target database host.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TRANSFERTARGET_HOST = host_name
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TRANSFERTARGET_SUDOPATH

Specifies the Sudo path on the dump transfer node.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TRANSFERTARGET_* parameters specify details for the target node to copy the Dump files from source node Data Pump dump location or transfer node directory path specified. Default target database host.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TRANSFERTARGET_SUDOPATH = path
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TRANSFERTARGET_USER

Specifies the host user name that has write permission to the indicated dump storage path.

The user specified in DUMPTRANSFERDETAILS_TRANSFERTARGET_USER should be allowed to

• Execute OCI CLI in the specified host to download the dumps from the Object Storage bucket if DATA_TRANSFER_MEDIUM=OSS

• Copy the dump files from the source node to the target host specified if DATA_TRANSFER_MEDIUM=COPY.

See Configuring the Transfer Medium and Specifying Transfer Nodes for more information about configuring the dump transfer details parameters.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TRANSFERTARGET_* parameters specify details for the target node to copy the Dump files from source node Data Pump dump location or transfer node directory path specified. Default target database host.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TRANSFERTARGET_USER = host_username
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

DUMPTRANSFERDETAILS_TRANSFERTARGET_USERKEY

Specifies the user's authentication key.

Parameter Relationships

The DUMPTRANSFERDETAILS_* parameters specify details to transfer dumps from the source node to the target node.

Supported modes of transfer are OSS and secure copy. Upload of dumps to OSS can be either through OCI CLI or Curl.

The DUMPTRANSFERDETAILS_TRANSFERTARGET_* parameters specify details for the target node to copy the Dump files from source node Data Pump dump location or transfer node directory path specified. Default target database host.

Property	Description
Syntax	DUMPTRANSFERDETAILS_TRANSFERTARGET_USERKEY = user_auth_key
Default value	No default value
Range of values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_TRANSFER_DUMPS_SRC phase is COMPLETED

EXCLUDEOBJECTS-LIST_ELEMENT_NUMBER

Specifies database objects to exclude from migration.

To exclude multiple objects, increment the integer appended to the parameter name, as shown in the examples below.

EXCLUDEOBJECTS-1=owner:ownerValue1st, objectName:objectNameValue1st
EXCLUDEOBJECTS-1=owner:ownerValue2nd, objectName:objectNameValue2nd

Property	Description
Syntax	EXCLUDEOBJECTS-LIST_ELEMENT_NUMBER = owner:ownerValue, objectName:objectNameValue,
Default value	There is no default value.
Range of values	owner: owner can be the OWNER value of a database object Note that when creating an exclude rule, you must enter the owner name in uppercase letters. If you use lowercase letters for the owner name the rule is ignored. For example, if you use the following settings then the objects specified in the first two rules are not excluded, but the third rule is valid so that owner's objects are excluded. EXCLUDEOBJECTS-1=owner:tpcc1, objectName:.* EXCLUDEOBJECTS-2=owner:tpcc2, objectName:.* EXCLUDEOBJECTS-3=owner:TEST9, objectName:.* objectName: objectName can be the OBJECT_NAME value of a database object. Only TABLE object types are supported for exclusion by Database Migration. You can filter owner and object values by any valid pattern in Java class Pattern. For example, you can enter .* in the objectName argument to exclude all tables (including views) owned by owner.
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED, or until ZDM_DATAPUMP_IMPORT_TGT phase when using DATA_TRANSFER_MEDIUM=DBLINK.

GOLDENGATEHUB_ADMINUSERNAME

Specifies the GoldenGate hub administrator user name.

Parameter Relationships

For online logical migration, you must set the GOLDENGATEHUB_* parameters to provide Zero Downtime Migration with details about Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATEHUB_ADMINUSERNAME = user_name
Default value	There is no default value
Range of values	Oracle GoldenGate hub's administrator user name
Required	No* *Required for online logical migration
Modifiable on Resume	Until ZDM_PREPARE_GG_HUB phase is COMPLETED.

GOLDENGATEHUB_COMPUTEID

Specifies the Oracle Cloud identifier of the VM.

Parameter Relationships

For online logical migration, you must set the GOLDENGATEHUB_* parameters to provide Zero Downtime Migration with details about Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATEHUB_COMPUTEID = vm_identifier
Default value	There is no default value
Range of values	Oracle Cloud identifier of the VM
Required	No* *Required for online logical migration
Modifiable on Resume	Until ZDM_PREPARE_GG_HUB phase is COMPLETED.

GOLDENGATEHUB_SOURCEDEPLOYMENTNAME

Specifies the name of the GoldenGate Microservices deployment to operate on the source database.

Parameter Relationships

For online logical migrations, you must set the GOLDENGATEHUB parameters to provide Zero Downtime Migration with details about Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATEHUB_SOURCEDEPLOYMENTNAME = GG_microservices_deployment_name
Default value	There is no default value
Range of values	Name of the GoldenGate Microservices deployment to operate on the source database
Required	No* *Required for online logical migration
Modifiable on Resume	Until ZDM_PREPARE_GG_HUB phase is COMPLETED.

GOLDENGATEHUB_TARGETDEPLOYMENTNAME

Specifies the name of the GoldenGate Microservices deployment to operate on the target database.

Parameter Relationships

For online logical migrations, you must set the GOLDENGATEHUB parameters to provide Zero Downtime Migration with details about Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATEHUB_TARGETDEPLOYMENTNAME = GG_microservices_deployment_name
Default value	There is no default value
Range of values	Name of the GoldenGate Microservices deployment to operate on the target database
Required	No* *Required for online logical migration
Modifiable on Resume	Until ZDM_PREPARE_GG_HUB phase is COMPLETED.

GOLDENGATEHUB_URL

Specifies the Oracle GoldenGate hub's REST endpoint.

Parameter Relationships

For online logical migrations, you must set the GOLDENGATEHUB parameters to provide Zero Downtime Migration with details about Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATEHUB_URL = GG_hub_rest_endpoint
Default value	There is no default value
Range of values	Oracle GoldenGate hub's REST endpoint
Required	No* *Required for online logical migration
Modifiable on Resume	Until ZDM_PREPARE_GG_HUB phase is COMPLETED.

GOLDENGATESETTINGS_ACCEPTABLELAG

Specifies GoldenGate end-to-end latency lag time

Zero Downtime Migration monitors GoldenGate end-to-end latency until the lag time is lower than the value (in seconds) specified in GOLDENGATESETTINGS_ACCEPTABLELAG.

Parameter Relationships

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_ACCEPTABLELAG = seconds
Default value	30 seconds
Required	No
Required	No
Modifiable on Resume	Until ZDM_MONITOR_GG_LAG phase is COMPLETED.

GOLDENGATESETTINGS_EXTRACT_NAME

Specifies a name for the GoldenGate Extract processes.

Parameter Relationships

The GOLDENGATESETTINGS_EXTRACT_* parameters define settings for the Integrated Extract process.

Only one Extract can be configured.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_EXTRACT_NAME = nameValue
Default value	There is no default value
Valid values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_EXTRACT_SRC phase is COMPLETED.

GOLDENGATESETTINGS_EXTRACT_PERFORMANCEPROFILE

Tunes Oracle GoldenGate Integrated Capture.

Use this setting to automatically configure relevant parameters to achieve the desired throughput and latency.

Parameter Relationships

The GOLDENGATESETTINGS_EXTRACT_* parameters define settings for the Integrated Extract process.

Only one Extract can be configured.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_EXTRACT_PERFORMANCEPROFILE = [HIGH | MEDIUM | LOW-RES]
Default value	HIGH
Valid values	HIGH, MEDIUM, LOW-RES
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_EXTRACT_SRC phase is COMPLETED.

GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_CHECKINTERVAL

Specifies the frequency in seconds with which Oracle GoldenGate checks for long-running transactions.

Parameter Relationships

GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_* parameters specify a length of time in seconds that a transaction can be open before Extract generates a warning message that the transaction is long-running.

The GOLDENGATESETTINGS_EXTRACT_* parameters define settings for the Integrated Extract process.

Only one Extract can be configured.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_CHECKINTERVAL = integer
Default value	There is no default value
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_EXTRACT_SRC phase is COMPLETED.

GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_DURATION

Specifies a length of time in seconds that a transaction can be open before the GoldenGate Extract process generates a warning message that the transaction is long-running.

Parameter Relationships

GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_* parameters specify a length of time in seconds that a transaction can be open before Extract generates a warning message that the transaction is long-running.

The GOLDENGATESETTINGS_EXTRACT_* parameters define settings for the Integrated Extract process.

Only one Extract can be configured.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_EXTRACT_WARNLONGTRANS_DURATION = integer
Default value	There is no default value
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_EXTRACT_SRC phase is COMPLETED.

GOLDENGATESETTINGS_REPLICAT_MAPPARALLELISM

Specifies the number of threads used to read GoldenGate trail files.

Valid for Parallel Replicat.

Parameter Relationships

The GOLDENGATESETTINGS_REPLICAT_* parameters define settings for the Parallel Replicat process.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_REPLICAT_MAPPARALLELISM = integer
Default value	4
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_REPLICAT_TGT phase is COMPLETED.

GOLDENGATESETTINGS_REPLICAT_MAXAPPLYPARALLELISM

Defines the range in which the GoldenGate Replicat automatically adjusts its apply parallelism.

Valid for Parallel Replicat.

Parameter Relationships

The GOLDENGATESETTINGS_REPLICAT_* parameters define settings for the Parallel Replicat process.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_REPLICAT_MAXAPPLYPARALLELISM = integer
Default value	50
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_REPLICAT_TGT phase is COMPLETED.

GOLDENGATESETTINGS_REPLICAT_MINAPPLYPARALLELISM

Defines the range in which the GoldenGate Replicat automatically adjusts its apply parallelism.

Valid for Parallel Replicat.

Parameter Relationships

The GOLDENGATESETTINGS_REPLICAT_* parameters define settings for the Parallel Replicat process.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_REPLICAT_MINAPPLYPARALLELISM = integer
Default value	4
Valid values	An integer value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_REPLICAT_TGT phase is COMPLETED.

GOLDENGATESETTINGS_REPLICAT_NAME

Specifies a name for the GoldenGate Replicat process.

Parameter Relationships

The GOLDENGATESETTINGS_REPLICAT_* parameters define settings for the Parallel Replicat process.

For online logical migrations, you can set the optional GOLDENGATESETTINGS_* parameters to provide Zero Downtime Migration with details about the Oracle GoldenGate Microservices configuration.

Property	Description
Syntax	GOLDENGATESETTINGS_REPLICAT_NAME = nameValue
Default value	There is no default value
Valid values	A string value is expected
Required	No
Modifiable on Resume	Until ZDM_CREATE_GG_REPLICAT_TGT phase is COMPLETED.

INCLUDEOBJECTS-LIST_ELEMENT_NUMBER

Specifies database objects to include for migration.

To include multiple objects, increment the integer appended to the parameter name, as shown in the examples below.

INCLUDEOBJECTS-1=owner:ownerValue1st, objectName:objectNameValue1st
INCLUDEOBJECTS-1=owner:ownerValue2nd, objectName:objectNameValue2nd

Property	Description
Syntax	INCLUDEOBJECTS-LIST_ELEMENT_NUMBER = owner:ownerValue, objectName:objectNameValue
Default value	There is no default value
Range of values	An entry specifying the owner and object name is expected, as shown in the examples above.
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_EXPORT_SRC phase is COMPLETED, or until ZDM_DATAPUMP_IMPORT_TGT phase when using DATA_TRANSFER_MEDIUM=DBLINK.

MIGRATION_METHOD

In a logical migration, specifies whether the migration is online logical or offline logical

The required MIGRATION_METHOD parameter specifies whether the migration is online (Data Pump with Oracle GoldenGate replication) or offline (Data Pump only).

Property	Description
Syntax	MIGRATION_METHOD = {ONLINE_LOGICAL | OFFLINE_LOGICAL}
Default value	OFFLINE_LOGICAL
Range of values	ONLINE_LOGICAL migrate the database with Data Pump, with replication using Oracle GoldenGate for minimal downtime OFFLINE_LOGICAL migrate the database with Data Pump, with no replication
Required	Yes
Modifiable on Resume	No

OCIAUTHENTICATIONDETAILS_REGIONID

Specifies the OCI region identifier.

See the Region Identifier column in the table at Regions and Availability Domains.

Parameter Relationships

To call REST APIs, you must configure the OCIAUTHENTICATIONDETAILS_* parameters.

Property	Description
Syntax	OCIAUTHENTICATIONDETAILS_REGIONID = region_id
Default value	There is no default value
Required	Yes
Modifiable on Resume	Yes

OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT

Specifies the fingerprint of the public API key.

See Required Keys and OCIDs for more information.

Parameter Relationships

To call REST APIs, you must configure the OCIAUTHENTICATIONDETAILS_* parameters.

Property	Description
Syntax	OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_FINGERPRINT = fingerprint
Default value	There is no default value
Required	Yes
Modifiable on Resume	Yes

OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE

Specifies the absolute path of API private key file.

See Required Keys and OCIDs for more information.

Parameter Relationships

To call REST APIs, you must configure the OCIAUTHENTICATIONDETAILS_* parameters.

Property	Description
Syntax	OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_PRIVATEKEYFILE = path
Default value	There is no default value
Required	Yes
Modifiable on Resume	Yes

OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID

Specifies the OCID of the OCI tenancy.

You can find the tenant OCID on OCI at Governance and Administration, Administration, Tenancy Details. The tenancy OCID is shown under Tenancy Information.

Example: ocid1.tenancy.oc1..aaaaaaaaba3pv6wkcr4jqae5f44n2b2m2yt2j6rx32uzr4h25vqstifsfdsq

See Managing the Tenancy and Required Keys and OCIDs for more information.

Parameter Relationships

To call OCI REST APIs, you must configure the OCIAUTHENTICATIONDETAILS_* parameters.

Property	Description
Syntax	OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_TENANTID = ocid_string
Default value	There is no default value
Valid values	A string value is expected
Required	Yes
Modifiable on Resume	Yes

OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID

Specifies the OCID of the IAM user.

You can find the IAM OCID on OCI at Console, Profile, User Settings.

See Managing Users and Required Keys and OCIDs for more information.

Parameter Relationships

To call OCI REST APIs, you must configure the OCIAUTHENTICATIONDETAILS_* parameters.

Property	Description
Syntax	OCIAUTHENTICATIONDETAILS_USERPRINCIPAL_USERID = userid
Default value	There is no default value
Required	Yes
Modifiable on Resume	Yes

OCIPROXY_HOSTNAME

Specifies the HTTP proxy host name.

Parameter Relationships

The OCIPROXY_* parameters specify details about the proxy for connecting to OCI REST endpoints.

Property	Description
Syntax	OCIPROXY_HOSTNAME = hostname
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

OCIPROXY_PORT

Specifies the HTTP proxy port number.

Parameter Relationships

The OCIPROXY_* parameters specify details about the proxy for connecting to OCI REST endpoints.

Property	Description
Syntax	OCIPROXY_PORT = port number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_ADMINUSERNAME

Specifies the source CDB administrator user name.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_* parameters specify connection details for the source database CDB root.

Property	Description
Syntax	SOURCECONTAINERDATABASE_ADMINUSERNAME = username
Default value	There is no default value
Required	No
Modifiable on Resume	No

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE

Specifies the identity file to access the bastion, as part of the database connection details for bastion-based access to the database.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_* parameters specify details for bastion based access to the database.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE = bastion_id_file
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP

Specifies the IP address of the source CDB bastion host, as part of the database connection details for bastion-based access to the database.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_* parameters specify details for bastion based access to the database.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP = bastion_ip_address
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT

Specifies the bastion host port, as part of the database connection details for bastion-based access to the container database (CDB).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_* parameters specify details for bastion based access to the database.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT = bastion_port_number
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP

Specifies the remote host IP address to access from the bastion, as part of the database connection details for bastion-based access to the container database (CDB).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_* parameters specify details for bastion based access to the database.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP = ip_address
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME

Specifies the user name to access the bastion, as part of the database connection details for bastion-based access to the container database (CDB).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_* parameters specify details for bastion based access to the database.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME = username
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST

Specifies the listener host name or IP address for the source container database (CDB).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_HOST = listener_host
Default value	There is no default value
Required	Not mandatory for migration jobs Not required for migrations to Autonomous Database.
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT

Specifies the listener port number for the source container database (CDB).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PORT = listener_port
Default value	There is no default value
Required	Not mandatory for migration jobs Not required for migrations to Autonomous Database.
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

Specifies the HTTPS proxy host name for the CDB.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_* parameters specify connection details for the source CDB root through an HTTP proxy.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME = proxy_hostname
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Specifies the HTTPS proxy host port number for the CDB.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_* parameters specify connection details for the source CDB root through an HTTP proxy.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT = proxy_port
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME

Specifies the fully qualified source CDB service name.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_* parameters specify connection details for the source database CDB root.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_SERVICENAME = service_name
Default value	There is no default value
Required	Not mandatory for migration jobs Not required for Autonomous Database
Modifiable on Resume	No

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION

Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for the CDB.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_* parameters specify details for TLS connection to the database CDB. These settings are not required if you are using TCP.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION = directory
Default value	There is no default value
Required	Not mandatory for migration jobs Not required for Autonomous Database Not required if you are using TCP
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME

Specifies the distinguished name (DN) of the database server (SSL_SERVER_CERT_DN).

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source CDB root.

The SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_* parameters specify details for TLS connection to the CDB. These settings are not required if you are using TCP.

Property	Description
Syntax	SOURCECONTAINERDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME = distinguished_name
Default value	There is no default value
Required	Not mandatory for migration jobs Not required for Autonomous Database Not required if you are using TCP
Modifiable on Resume	Yes

SOURCECONTAINERDATABASE_GGADMINUSERNAME

Specifies the source CDB GoldenGate administrator user name.

Parameter Relationships

For online logical migrations, the SOURCECONTAINERDATABASE_* parameters specify connection details for the source database CDB root.

Property	Description
Syntax	SOURCECONTAINERDATABASE_GGADMINUSERNAME = GoldenGate administrator username
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	No

SOURCEDATABASE_ADMINUSERNAME

Specifies the source database administrator user name.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_ADMINUSERNAME = source administrator username
Default value	There is no default value
Required	Yes
Modifiable on Resume	No

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE

Specifies the identity file to access the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE = identity file
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP

Specifies the IP address of the bastion host for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP = ip address
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT

Specifies the port number of the bastion host for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT = port_number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP

Specifies the remote host IP address to access from the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP = ip_address
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME

Specifies the user name to access the bastion for bastion-based access to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME = username
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_HOST

Specifies the source database listener host name or IP address.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_HOST = hostname_or_ip
Default value	There is no default value
Required	Yes* *Not required for Autonomous Database.
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_PORT

Specifies the source database listener port number.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_PORT = listener port number
Default value	There is no default value
Required	Yes* *Not required for Autonomous Database.
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

Specifies the proxy host name to connect to the source database through an HTTPS proxy.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME = proxy host name
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Specifies the HTTP proxy port number to connect to the source database through an HTTPS proxy.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT = proxy port number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME

Specifies the source database fully qualified service name.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_SERVICENAME = service name
Default value	There is no default value
Required	Yes* *Not required for Autonomous Database
Modifiable on Resume	No

SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION

Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for a TLS connection to the database.

Parameter Relationships

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION = directory
Default value	There is no default value
Required	Not mandatory for migration jobs Not required if using TCP Not required for Autonomous Database
Modifiable on Resume	Yes

SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME

Specifies the distinguished name (DN) of the database server (SSL_SERVER_CERT_DN) for a TLS connection to the database.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

The SOURCEDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME = distinguished_name
Default value	There is no default value
Required	Not mandatory for migration jobs Not required if using TCP Not required for Autonomous Database
Modifiable on Resume	Yes

SOURCEDATABASE_ENVIRONMENT_DBTYPE

Indicates the type of database to migrate from the specified environment.

If you specify that the source database environment is Amazon Web Services RDS by setting SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON, then you must also set SOURCEDATABASE_ENVIRONMENT_DBTYPE=RDS_ORACLE.

See Migrating from Amazon Web Services RDS to Oracle Autonomous Database.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_ENVIRONMENT_DBTYPE = RDS_ORACLE
Default value	RDS_ORACLE
Required	No
Modifiable on Resume	No

SOURCEDATABASE_ENVIRONMENT_NAME

Specifies the environment of the source database.

You can specify whether the source database environment is Oracle (ORACLE) or Amazon Web Services RDS (AMAZON).

If you set SOURCEDATABASE_ENVIRONMENT_NAME=AMAZON you must also set SOURCEDATABASE_ENVIRONMENT_DBTYPE=RDS_ORACLE. See Migrating from Amazon Web Services RDS to Oracle Autonomous Database.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_ENVIRONMENT_NAME = [ORACLE|AMAZON]
Default value	ORACLE
Required	No
Modifiable on Resume	No

SOURCEDATABASE_GGADMINUSERNAME

Specifies the GoldenGate administrator user name for online logical migrations.

Parameter Relationships

The SOURCEDATABASE_* parameters specify connection details for the source database.

Property	Description
Syntax	SOURCEDATABASE_GGADMINUSERNAME = gg_admin_username
Default value	There is no default value
Required	No
Modifiable on Resume	No

TABLESPACEDETAILS_AUTOCREATE

Specifies whether Zero Downtime Migration automatically creates tablespaces at the target database necessary to allocate space in the database to contain schema objects.

This option is prohibited for Autonomous Database Shared targets.

See Automatic Tablespace Creation for more information.

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_AUTOCREATE={TRUE | FALSE}
Default value	FALSE
Range of values	TRUE - Zero Downtime Migration automatically creates tablespaces FALSE - Zero Downtime Migration does not create tablespaces
Required	No This option is prohibited for Autonomous Database Shared targets.
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED

TABLESPACEDETAILS_AUTOREMAP

Specifies whether Zero Downtime Migration automatically remaps a tablespace at the target database.

See Automatic Tablespace Remap for more information.

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_AUTOREMAP={TRUE | FALSE}
Default value	FALSE
Range of values	TRUE - Zero Downtime Migration automatically remaps tablespaces FALSE - Zero Downtime Migration does not remap tablespaces
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED

TABLESPACEDETAILS_EXCLUDE

Specifies tablespaces to be excluded from automatic creation at the target database.

See Automatic Tablespace Creation for more information.

Example

TABLESPACEDETAILS_EXCLUDE='B2B_LOB_TS','B2B_HR_TS'

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_EXCLUDE=tablespace_names
Default value	By default SYSTEM, SYSAUX, and USERS tablespaces are excluded.
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED

TABLESPACEDETAILS_EXTENTSIZEMB

Specifies an extent size for AUTOEXTEND in support of automatic tablespace creation.

Properly setting TABLESPACEDETAILS_EXTENTSIZEMB enables AUTOEXTEND to avoid extend errors when automatic tablespace creation is enabled.

See Automatic Tablespace Creation for more information.

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_EXTENTSIZEMB=MB
Default value	500
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED

TABLESPACEDETAILS_REMAPTARGET

Specifies tablespaces to be remapped.

For a tablespace to be used as REMAP target, the user performing the import operation, for example SYSTEM, should have some quota on the chosen tablespace.

See Automatic Tablespace Remap for more information.

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_REMAPTARGET=target_tablespace_names
Default value	By default the DATA tablespace is remapped.
Required	No
Modifiable on Resume	Until ZDM_DATAPUMP_IMPORT_TGT phase is COMPLETED

TABLESPACEDETAILS_USEBIGFILE

Specifies whether to use bigfile tablespaces, if Zero Downtime Migration is configured to create tablespaces automatically.

Using bigfile tablespaces, which can be up to 128 TB, significantly reduces the number of data files for your database. Combined with Oracle Managed Files (OMF), bigfile tablespaces simplify data file management.

See Automatic Tablespace Creation for more information.

Parameter Relationships

In a logical migration, the TABLESPACEDETAILS_* parameters specify details that allow Zero Downtime Migration to automatically create the required tablespaces at target database..

Property	Description
Syntax	TABLESPACEDETAILS_USEBIGFILE={TRUE | FALSE}
Default value	FALSE
Range of values	TRUE - Zero Downtime Migration automatically creates bigfile tablespaces FALSE - Zero Downtime Migration does not create bigfile tablespaces
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED

TARGETDATABASE_ADMINUSERNAME

Specifies the target database administrator user name.

Parameter Relationships

The TARGETDATABASE_* parameters specify connection details for the target OCI database.

Property	Description
Syntax	TARGETDATABASE_ADMINUSERNAME = username
Default value	There is no default value
Required	Yes
Modifiable on Resume	No

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE

Specifies the identity file to access the bastion for bastion-based access to the target database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IDENTITYFILE = bastion_id_file
Default value	There is no default value
Required	Not mandatory for migration jobs
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP

Specifies the IP address of the bastion host for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_IP = ip address
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT

Specifies the port number of the bastion host for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_PORT = port_number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP

Specifies the remote host IP address to access from the bastion for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_REMOTEHOSTIP = ip_address
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME

Specifies the user name to access the bastion for bastion-based access to database.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_BASTIONDETAILS_USERNAME = username
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_HOST

Specifies the listener host name or IP address.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS parameters specify connection details for the target OCI database.

These properties are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_HOST = hostname_or_ip
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_PORT

Specifies the listener port number.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_PORT = listener port number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME

Specifies the proxy host name for connecting to the target database through an HTTPS proxy.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_HOSTNAME = proxy host name
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT

Specifies the HTTP proxy port number for connecting to the source database through an HTTPS proxy.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_PROXYDETAILS_PORT = proxy port number
Default value	There is no default value
Required	No
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME

Specifies the fully qualified service name.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_SERVICENAME = service name
Default value	There is no default value
Required	No
Modifiable on Resume	No

TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION

Specifies the directory containing client credentials (wallet, keystore, trustfile, etc.) for a TLS connection.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_CREDENTIALSLOCATION = directory
Default value	There is no default value
Required	Not mandatory for migrations Not required if using TCP
Modifiable on Resume	Yes

TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME

Specifies the distinguished name (DN) of the database server (SSL_SERVER_CERT_DN) for a TLS connection.

Parameter Relationships

The TARGETDATABASE_CONNECTIONDETAILS_* parameters specify connection details for the target OCI database.

These are optional for Autonomous Database; however if an HTTP proxy is required to connect, specify them.

Property	Description
Syntax	TARGETDATABASE_CONNECTIONDETAILS_TLSDETAILS_DISTINGUISHEDNAME = distinguished_name
Default value	There is no default value
Required	Not mandatory for migrations Not required if using TCP
Modifiable on Resume	Yes

TARGETDATABASE_GGADMINUSERNAME

Specifies the GoldenGate administrator user name for online logical migrations.

Parameter Relationships

The TARGETDATABASE_* parameters specify connection details for the target OCI database.

Property	Description
Syntax	TARGETDATABASE_GGADMINUSERNAME = gg_admin_username
Default value	There is no default value
Required	No
Modifiable on Resume	No

TARGETDATABASE_OCID

Specifies the Oracle Cloud resource identifier.

Parameter Relationships

The TARGETDATABASE_* parameters specify connection details for the target OCI database.

Property	Description
Syntax	TARGETDATABASE_OCID = ocid
Default value	There is no default value
Required	Yes
Modifiable on Resume	No

WALLET_AMAZONS3SECRET

Specifies the Amazon S3 Secret Key wallet path.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_AMAZONS3SECRET = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_DATAPUMPENCRYPTION

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the Data Pump encryption password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_DATAPUMPENCRYPTION = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_OGGADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the Oracle GoldenGate hub administrative password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_OGGADMIN = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_SOURCECONTAINER

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the source database administrative user password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_SOURCECONTAINER = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_SOURCECGGADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the source database administrative c##ggadmin user password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_SOURCECGGADMIN = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_SOURCEGGADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the source database administrative user ggadmin password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_SOURCEGGADMIN = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.

WALLET_TARGETADMIN

Specifies the absolute path to the directory that contains the auto login wallet file cwallet.sso, which is used to get the target database administrative admin password.

The path should be resolvable from the Zero Downtime Migration service host.

About the WALLET_* Parameters

The WALLET_* parameters specify the full path for the auto login wallet file on the Zero Downtime Migration service host.

Property	Description
Syntax	WALLET_TARGETADMIN = wallet_path
Default value	There is no default value
Required	No
Modifiable on Resume	Until ZDM_PREPARE_DATAPUMP_SRC phase is COMPLETED.