Oracle Cloud Infrastructure v3.3.0 published on Thursday, Jul 17, 2025 by Pulumi
oci.DatabaseMigration.getMigrations
Explore with Pulumi AI
Example Usage
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
Example coming soon!
variables:
testMigrations:
fn::invoke:
function: oci:DatabaseMigration:getMigrations
arguments:
compartmentId: ${compartmentId}
displayName: ${migrationDisplayName}
lifecycleDetails: ${migrationLifecycleDetails}
state: ${migrationState}
Using getMigrations
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getMigrations(args: GetMigrationsArgs, opts?: InvokeOptions): Promise<GetMigrationsResult>
function getMigrationsOutput(args: GetMigrationsOutputArgs, opts?: InvokeOptions): Output<GetMigrationsResult>
def get_migrations(migration_id: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetMigrationsResult
def get_migrations_output(migration_id: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetMigrationsResult]
func GetMigrations(ctx *Context, args *GetMigrationsArgs, opts ...InvokeOption) (*GetMigrationsResult, error)
func GetMigrationsOutput(ctx *Context, args *GetMigrationsOutputArgs, opts ...InvokeOption) GetMigrationsResultOutput
> Note: This function is named GetMigrations
in the Go SDK.
public static class GetMigrations
{
public static Task<GetMigrationsResult> InvokeAsync(GetMigrationsArgs args, InvokeOptions? opts = null)
public static Output<GetMigrationsResult> Invoke(GetMigrationsInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetMigrationsResult> getMigrations(GetMigrationsArgs args, InvokeOptions options)
public static Output<GetMigrationsResult> getMigrations(GetMigrationsArgs args, InvokeOptions options)
fn::invoke:
function: oci:DatabaseMigration/getMigrations:getMigrations
arguments:
# arguments dictionary
The following arguments are supported:
- Migration
Id string
- Migration
Id string
- migration
Id String
- migration
Id string
- migration_
id str
- migration
Id String
getMigrations Result
The following output properties are available:
- Advanced
Parameters List<GetMigrations Advanced Parameter> - List of Migration Parameter objects.
- Advisor
Settings List<GetMigrations Advisor Setting> - Details about Oracle Advisor Settings.
- Bulk
Include stringExclude Data - Compartment
Id string - The OCID of the resource being referenced.
- Data
Transfer List<GetMedium Details Migrations Data Transfer Medium Detail> - Optional additional properties for data transfer.
- Database
Combination string - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Dictionary<string, string>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Description string
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects List<GetMigrations Exclude Object> - Executing
Job stringId - The OCID of the resource being referenced.
- Dictionary<string, string>
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details List<GetMigrations Ggs Detail> - Optional settings for Oracle GoldenGate processes
- Hub
Details List<GetMigrations Hub Detail> - Details about Oracle GoldenGate Microservices.
- Id string
- The OCID of the resource being referenced.
- Include
Objects List<GetMigrations Include Object> - Initial
Load List<GetSettings Migrations Initial Load Setting> - Optional settings for Data Pump Export and Import jobs
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- Migration
Id string - Source
Container stringDatabase Connection Id - The OCID of the resource being referenced.
- Source
Database stringConnection Id - The OCID of the resource being referenced.
- Source
Standby stringDatabase Connection Id - The OCID of the resource being referenced.
- State string
- The current state of the Migration resource.
- Dictionary<string, string>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Target
Database stringConnection Id - The OCID of the resource being referenced.
- Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- Advanced
Parameters []GetMigrations Advanced Parameter - List of Migration Parameter objects.
- Advisor
Settings []GetMigrations Advisor Setting - Details about Oracle Advisor Settings.
- Bulk
Include stringExclude Data - Compartment
Id string - The OCID of the resource being referenced.
- Data
Transfer []GetMedium Details Migrations Data Transfer Medium Detail - Optional additional properties for data transfer.
- Database
Combination string - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- map[string]string
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- Description string
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- Exclude
Objects []GetMigrations Exclude Object - Executing
Job stringId - The OCID of the resource being referenced.
- map[string]string
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- Ggs
Details []GetMigrations Ggs Detail - Optional settings for Oracle GoldenGate processes
- Hub
Details []GetMigrations Hub Detail - Details about Oracle GoldenGate Microservices.
- Id string
- The OCID of the resource being referenced.
- Include
Objects []GetMigrations Include Object - Initial
Load []GetSettings Migrations Initial Load Setting - Optional settings for Data Pump Export and Import jobs
- Lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- Migration
Id string - Source
Container stringDatabase Connection Id - The OCID of the resource being referenced.
- Source
Database stringConnection Id - The OCID of the resource being referenced.
- Source
Standby stringDatabase Connection Id - The OCID of the resource being referenced.
- State string
- The current state of the Migration resource.
- map[string]string
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- Target
Database stringConnection Id - The OCID of the resource being referenced.
- Time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- Wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters List<GetMigrations Advanced Parameter> - List of Migration Parameter objects.
- advisor
Settings List<GetMigrations Advisor Setting> - Details about Oracle Advisor Settings.
- bulk
Include StringExclude Data - compartment
Id String - The OCID of the resource being referenced.
- data
Transfer List<GetMedium Details Migrations Data Transfer Medium Detail> - Optional additional properties for data transfer.
- database
Combination String - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Map<String,String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- description String
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<GetMigrations Exclude Object> - executing
Job StringId - The OCID of the resource being referenced.
- Map<String,String>
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details List<GetMigrations Ggs Detail> - Optional settings for Oracle GoldenGate processes
- hub
Details List<GetMigrations Hub Detail> - Details about Oracle GoldenGate Microservices.
- id String
- The OCID of the resource being referenced.
- include
Objects List<GetMigrations Include Object> - initial
Load List<GetSettings Migrations Initial Load Setting> - Optional settings for Data Pump Export and Import jobs
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- migration
Id String - source
Container StringDatabase Connection Id - The OCID of the resource being referenced.
- source
Database StringConnection Id - The OCID of the resource being referenced.
- source
Standby StringDatabase Connection Id - The OCID of the resource being referenced.
- state String
- The current state of the Migration resource.
- Map<String,String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- target
Database StringConnection Id - The OCID of the resource being referenced.
- time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters GetMigrations Advanced Parameter[] - List of Migration Parameter objects.
- advisor
Settings GetMigrations Advisor Setting[] - Details about Oracle Advisor Settings.
- bulk
Include stringExclude Data - compartment
Id string - The OCID of the resource being referenced.
- data
Transfer GetMedium Details Migrations Data Transfer Medium Detail[] - Optional additional properties for data transfer.
- database
Combination string - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- {[key: string]: string}
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- description string
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name string - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects GetMigrations Exclude Object[] - executing
Job stringId - The OCID of the resource being referenced.
- {[key: string]: string}
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details GetMigrations Ggs Detail[] - Optional settings for Oracle GoldenGate processes
- hub
Details GetMigrations Hub Detail[] - Details about Oracle GoldenGate Microservices.
- id string
- The OCID of the resource being referenced.
- include
Objects GetMigrations Include Object[] - initial
Load GetSettings Migrations Initial Load Setting[] - Optional settings for Data Pump Export and Import jobs
- lifecycle
Details string - Additional status related to the execution and current state of the Migration.
- migration
Id string - source
Container stringDatabase Connection Id - The OCID of the resource being referenced.
- source
Database stringConnection Id - The OCID of the resource being referenced.
- source
Standby stringDatabase Connection Id - The OCID of the resource being referenced.
- state string
- The current state of the Migration resource.
- {[key: string]: string}
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- target
Database stringConnection Id - The OCID of the resource being referenced.
- time
Created string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Last stringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Updated string - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- wait
After string - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced_
parameters Sequence[GetMigrations Advanced Parameter] - List of Migration Parameter objects.
- advisor_
settings Sequence[GetMigrations Advisor Setting] - Details about Oracle Advisor Settings.
- bulk_
include_ strexclude_ data - compartment_
id str - The OCID of the resource being referenced.
- data_
transfer_ Sequence[Getmedium_ details Migrations Data Transfer Medium Detail] - Optional additional properties for data transfer.
- database_
combination str - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Mapping[str, str]
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- description str
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display_
name str - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude_
objects Sequence[GetMigrations Exclude Object] - executing_
job_ strid - The OCID of the resource being referenced.
- Mapping[str, str]
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs_
details Sequence[GetMigrations Ggs Detail] - Optional settings for Oracle GoldenGate processes
- hub_
details Sequence[GetMigrations Hub Detail] - Details about Oracle GoldenGate Microservices.
- id str
- The OCID of the resource being referenced.
- include_
objects Sequence[GetMigrations Include Object] - initial_
load_ Sequence[Getsettings Migrations Initial Load Setting] - Optional settings for Data Pump Export and Import jobs
- lifecycle_
details str - Additional status related to the execution and current state of the Migration.
- migration_
id str - source_
container_ strdatabase_ connection_ id - The OCID of the resource being referenced.
- source_
database_ strconnection_ id - The OCID of the resource being referenced.
- source_
standby_ strdatabase_ connection_ id - The OCID of the resource being referenced.
- state str
- The current state of the Migration resource.
- Mapping[str, str]
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- target_
database_ strconnection_ id - The OCID of the resource being referenced.
- time_
created str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time_
last_ strmigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time_
updated str - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - type str
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- wait_
after str - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
- advanced
Parameters List<Property Map> - List of Migration Parameter objects.
- advisor
Settings List<Property Map> - Details about Oracle Advisor Settings.
- bulk
Include StringExclude Data - compartment
Id String - The OCID of the resource being referenced.
- data
Transfer List<Property Map>Medium Details - Optional additional properties for data transfer.
- database
Combination String - The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.
- Map<String>
- Defined tags for this resource. Each key is predefined and scoped to a namespace. Example:
{"foo-namespace.bar-key": "value"}
- description String
- A user-friendly description. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- display
Name String - A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.
- exclude
Objects List<Property Map> - executing
Job StringId - The OCID of the resource being referenced.
- Map<String>
- Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
- ggs
Details List<Property Map> - Optional settings for Oracle GoldenGate processes
- hub
Details List<Property Map> - Details about Oracle GoldenGate Microservices.
- id String
- The OCID of the resource being referenced.
- include
Objects List<Property Map> - initial
Load List<Property Map>Settings - Optional settings for Data Pump Export and Import jobs
- lifecycle
Details String - Additional status related to the execution and current state of the Migration.
- migration
Id String - source
Container StringDatabase Connection Id - The OCID of the resource being referenced.
- source
Database StringConnection Id - The OCID of the resource being referenced.
- source
Standby StringDatabase Connection Id - The OCID of the resource being referenced.
- state String
- The current state of the Migration resource.
- Map<String>
- Usage of system tag keys. These predefined keys are scoped to namespaces. Example:
{"orcl-cloud.free-tier-retained": "true"}
- target
Database StringConnection Id - The OCID of the resource being referenced.
- time
Created String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Last StringMigration - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - time
Updated String - An RFC3339 formatted datetime string such as
2016-08-25T21:10:29.600Z
. - type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- wait
After String - You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.
Supporting Types
GetMigrationsAdvancedParameter
- Data
Type string - Parameter data type.
- Name string
- Name of directory object in database
- Value string
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- Data
Type string - Parameter data type.
- Name string
- Name of directory object in database
- Value string
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type String - Parameter data type.
- name String
- Name of directory object in database
- value String
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type string - Parameter data type.
- name string
- Name of directory object in database
- value string
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data_
type str - Parameter data type.
- name str
- Name of directory object in database
- value str
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
- data
Type String - Parameter data type.
- name String
- Name of directory object in database
- value String
- If a STRING data type then the value should be an array of characters, if a INTEGER data type then the value should be an integer value, if a FLOAT data type then the value should be an float value, if a BOOLEAN data type then the value should be TRUE or FALSE.
GetMigrationsAdvisorSetting
- Is
Ignore boolErrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- Is
Skip boolAdvisor - True to skip the Pre-Migration Advisor execution. Default is false.
- Is
Ignore boolErrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- Is
Skip boolAdvisor - True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore BooleanErrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip BooleanAdvisor - True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore booleanErrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip booleanAdvisor - True to skip the Pre-Migration Advisor execution. Default is false.
- is_
ignore_ boolerrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is_
skip_ booladvisor - True to skip the Pre-Migration Advisor execution. Default is false.
- is
Ignore BooleanErrors - True to not interrupt migration execution due to Pre-Migration Advisor errors. Default is false.
- is
Skip BooleanAdvisor - True to skip the Pre-Migration Advisor execution. Default is false.
GetMigrationsDataTransferMediumDetail
- Access
Key stringId - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- Name string
- Name of directory object in database
- Object
Storage List<GetBuckets Migrations Data Transfer Medium Detail Object Storage Bucket> - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- Region string
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- Secret
Access stringKey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- OCID of the shared storage mount target
- Sources
List<Get
Migrations Data Transfer Medium Detail Source> - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Targets
List<Get
Migrations Data Transfer Medium Detail Target> - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- Access
Key stringId - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- Name string
- Name of directory object in database
- Object
Storage []GetBuckets Migrations Data Transfer Medium Detail Object Storage Bucket - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- Region string
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- Secret
Access stringKey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- OCID of the shared storage mount target
- Sources
[]Get
Migrations Data Transfer Medium Detail Source - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Targets
[]Get
Migrations Data Transfer Medium Detail Target - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- access
Key StringId - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name String
- Name of directory object in database
- object
Storage List<GetBuckets Migrations Data Transfer Medium Detail Object Storage Bucket> - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region String
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access StringKey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- String
- OCID of the shared storage mount target
- sources
List<Get
Migrations Data Transfer Medium Detail Source> - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- targets
List<Get
Migrations Data Transfer Medium Detail Target> - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- access
Key stringId - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name string
- Name of directory object in database
- object
Storage GetBuckets Migrations Data Transfer Medium Detail Object Storage Bucket[] - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region string
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access stringKey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- string
- OCID of the shared storage mount target
- sources
Get
Migrations Data Transfer Medium Detail Source[] - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- targets
Get
Migrations Data Transfer Medium Detail Target[] - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- access_
key_ strid - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name str
- Name of directory object in database
- object_
storage_ Sequence[Getbuckets Migrations Data Transfer Medium Detail Object Storage Bucket] - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region str
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret_
access_ strkey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- str
- OCID of the shared storage mount target
- sources
Sequence[Get
Migrations Data Transfer Medium Detail Source] - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- targets
Sequence[Get
Migrations Data Transfer Medium Detail Target] - Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type str
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- access
Key StringId - AWS access key credentials identifier Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- name String
- Name of directory object in database
- object
Storage List<Property Map>Buckets - In lieu of a network database link, Oracle Cloud Infrastructure Object Storage bucket will be used to store Data Pump dump files for the migration. Additionally, it can be specified alongside a database link data transfer medium.
- region String
- AWS region code where the S3 bucket is located. Region code should match the documented available regions: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-regions-availability-zones.html#concepts-available-regions
- secret
Access StringKey - AWS secret access key credentials Details: https://docs.aws.amazon.com/general/latest/gr/aws-sec-cred-types.html#access-keys-and-secret-access-keys
- String
- OCID of the shared storage mount target
- sources List<Property Map>
- Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- targets List<Property Map>
- Optional additional properties for dump transfer in source or target host. Default kind is CURL.
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
GetMigrationsDataTransferMediumDetailObjectStorageBucket
GetMigrationsDataTransferMediumDetailSource
- Kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- Kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind str
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci_
home str - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet_
location str - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
GetMigrationsDataTransferMediumDetailTarget
- Kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- Kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- Oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- Wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind string
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home string - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location string - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind str
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci_
home str - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet_
location str - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
- kind String
- Type of dump transfer to use during migration in source or target host. Default kind is CURL
- oci
Home String - Path to the Oracle Cloud Infrastructure CLI installation in the node.
- wallet
Location String - Directory path to Oracle Cloud Infrastructure SSL wallet location on Db server node.
GetMigrationsExcludeObject
- Is
Omit boolExcluded Table From Replication - Object string
- Owner string
- Schema string
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- Is
Omit boolExcluded Table From Replication - Object string
- Owner string
- Schema string
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit BooleanExcluded Table From Replication - object String
- owner String
- schema String
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit booleanExcluded Table From Replication - object string
- owner string
- schema string
- type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is_
omit_ boolexcluded_ table_ from_ replication - object str
- owner str
- schema str
- type str
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit BooleanExcluded Table From Replication - object String
- owner String
- schema String
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
GetMigrationsGgsDetail
- Acceptable
Lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Extracts
List<Get
Migrations Ggs Detail Extract> - Parameters for Extract processes.
- Ggs
Deployments List<GetMigrations Ggs Detail Ggs Deployment> - Details about Oracle GoldenGate GGS Deployment.
- Replicats
List<Get
Migrations Ggs Detail Replicat> - Parameters for Replicat processes.
- Acceptable
Lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Extracts
[]Get
Migrations Ggs Detail Extract - Parameters for Extract processes.
- Ggs
Deployments []GetMigrations Ggs Detail Ggs Deployment - Details about Oracle GoldenGate GGS Deployment.
- Replicats
[]Get
Migrations Ggs Detail Replicat - Parameters for Replicat processes.
- acceptable
Lag Integer - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extracts
List<Get
Migrations Ggs Detail Extract> - Parameters for Extract processes.
- ggs
Deployments List<GetMigrations Ggs Detail Ggs Deployment> - Details about Oracle GoldenGate GGS Deployment.
- replicats
List<Get
Migrations Ggs Detail Replicat> - Parameters for Replicat processes.
- acceptable
Lag number - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extracts
Get
Migrations Ggs Detail Extract[] - Parameters for Extract processes.
- ggs
Deployments GetMigrations Ggs Detail Ggs Deployment[] - Details about Oracle GoldenGate GGS Deployment.
- replicats
Get
Migrations Ggs Detail Replicat[] - Parameters for Replicat processes.
- acceptable_
lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extracts
Sequence[Get
Migrations Ggs Detail Extract] - Parameters for Extract processes.
- ggs_
deployments Sequence[GetMigrations Ggs Detail Ggs Deployment] - Details about Oracle GoldenGate GGS Deployment.
- replicats
Sequence[Get
Migrations Ggs Detail Replicat] - Parameters for Replicat processes.
- acceptable
Lag Number - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- extracts List<Property Map>
- Parameters for Extract processes.
- ggs
Deployments List<Property Map> - Details about Oracle GoldenGate GGS Deployment.
- replicats List<Property Map>
- Parameters for Replicat processes.
GetMigrationsGgsDetailExtract
- Long
Trans intDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - Replicat performance.
- Long
Trans intDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - Replicat performance.
- long
Trans IntegerDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - Replicat performance.
- long
Trans numberDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile string - Replicat performance.
- long_
trans_ intduration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance_
profile str - Replicat performance.
- long
Trans NumberDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - Replicat performance.
GetMigrationsGgsDetailGgsDeployment
- Deployment
Id string - The OCID of the resource being referenced.
- Ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- Deployment
Id string - The OCID of the resource being referenced.
- Ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- deployment
Id String - The OCID of the resource being referenced.
- ggs
Admin StringCredentials Secret Id - The OCID of the resource being referenced.
- deployment
Id string - The OCID of the resource being referenced.
- ggs
Admin stringCredentials Secret Id - The OCID of the resource being referenced.
- deployment_
id str - The OCID of the resource being referenced.
- ggs_
admin_ strcredentials_ secret_ id - The OCID of the resource being referenced.
- deployment
Id String - The OCID of the resource being referenced.
- ggs
Admin StringCredentials Secret Id - The OCID of the resource being referenced.
GetMigrationsGgsDetailReplicat
- Performance
Profile string - Replicat performance.
- Performance
Profile string - Replicat performance.
- performance
Profile String - Replicat performance.
- performance
Profile string - Replicat performance.
- performance_
profile str - Replicat performance.
- performance
Profile String - Replicat performance.
GetMigrationsHubDetail
- Acceptable
Lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Compute
Id string - The OCID of the resource being referenced.
- Extracts
List<Get
Migrations Hub Detail Extract> - Parameters for Extract processes.
- Key
Id string - The OCID of the resource being referenced.
- Replicats
List<Get
Migrations Hub Detail Replicat> - Parameters for Replicat processes.
- Rest
Admin List<GetCredentials Migrations Hub Detail Rest Admin Credential> - Database Administrator Credentials details.
- Url string
- Endpoint URL.
- Vault
Id string - The OCID of the resource being referenced.
- Acceptable
Lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- Compute
Id string - The OCID of the resource being referenced.
- Extracts
[]Get
Migrations Hub Detail Extract - Parameters for Extract processes.
- Key
Id string - The OCID of the resource being referenced.
- Replicats
[]Get
Migrations Hub Detail Replicat - Parameters for Replicat processes.
- Rest
Admin []GetCredentials Migrations Hub Detail Rest Admin Credential - Database Administrator Credentials details.
- Url string
- Endpoint URL.
- Vault
Id string - The OCID of the resource being referenced.
- acceptable
Lag Integer - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id String - The OCID of the resource being referenced.
- extracts
List<Get
Migrations Hub Detail Extract> - Parameters for Extract processes.
- key
Id String - The OCID of the resource being referenced.
- replicats
List<Get
Migrations Hub Detail Replicat> - Parameters for Replicat processes.
- rest
Admin List<GetCredentials Migrations Hub Detail Rest Admin Credential> - Database Administrator Credentials details.
- url String
- Endpoint URL.
- vault
Id String - The OCID of the resource being referenced.
- acceptable
Lag number - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id string - The OCID of the resource being referenced.
- extracts
Get
Migrations Hub Detail Extract[] - Parameters for Extract processes.
- key
Id string - The OCID of the resource being referenced.
- replicats
Get
Migrations Hub Detail Replicat[] - Parameters for Replicat processes.
- rest
Admin GetCredentials Migrations Hub Detail Rest Admin Credential[] - Database Administrator Credentials details.
- url string
- Endpoint URL.
- vault
Id string - The OCID of the resource being referenced.
- acceptable_
lag int - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute_
id str - The OCID of the resource being referenced.
- extracts
Sequence[Get
Migrations Hub Detail Extract] - Parameters for Extract processes.
- key_
id str - The OCID of the resource being referenced.
- replicats
Sequence[Get
Migrations Hub Detail Replicat] - Parameters for Replicat processes.
- rest_
admin_ Sequence[Getcredentials Migrations Hub Detail Rest Admin Credential] - Database Administrator Credentials details.
- url str
- Endpoint URL.
- vault_
id str - The OCID of the resource being referenced.
- acceptable
Lag Number - ODMS will monitor GoldenGate end-to-end latency until the lag time is lower than the specified value in seconds.
- compute
Id String - The OCID of the resource being referenced.
- extracts List<Property Map>
- Parameters for Extract processes.
- key
Id String - The OCID of the resource being referenced.
- replicats List<Property Map>
- Parameters for Replicat processes.
- rest
Admin List<Property Map>Credentials - Database Administrator Credentials details.
- url String
- Endpoint URL.
- vault
Id String - The OCID of the resource being referenced.
GetMigrationsHubDetailExtract
- Long
Trans intDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - Replicat performance.
- Long
Trans intDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- Performance
Profile string - Replicat performance.
- long
Trans IntegerDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - Replicat performance.
- long
Trans numberDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile string - Replicat performance.
- long_
trans_ intduration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance_
profile str - Replicat performance.
- long
Trans NumberDuration - Length of time (in seconds) that a transaction can be open before Extract generates a warning message that the transaction is long-running. If not specified, Extract will not generate a warning on long-running transactions.
- performance
Profile String - Replicat performance.
GetMigrationsHubDetailReplicat
- Performance
Profile string - Replicat performance.
- Performance
Profile string - Replicat performance.
- performance
Profile String - Replicat performance.
- performance
Profile string - Replicat performance.
- performance_
profile str - Replicat performance.
- performance
Profile String - Replicat performance.
GetMigrationsHubDetailRestAdminCredential
GetMigrationsIncludeObject
- Is
Omit boolExcluded Table From Replication - Object string
- Owner string
- Schema string
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- Is
Omit boolExcluded Table From Replication - Object string
- Owner string
- Schema string
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit BooleanExcluded Table From Replication - object String
- owner String
- schema String
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit booleanExcluded Table From Replication - object string
- owner string
- schema string
- type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is_
omit_ boolexcluded_ table_ from_ replication - object str
- owner str
- schema str
- type str
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- is
Omit BooleanExcluded Table From Replication - object String
- owner String
- schema String
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
GetMigrationsInitialLoadSetting
- Compatibilities List<string>
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- Data
Pump List<GetParameters Migrations Initial Load Setting Data Pump Parameter> - Optional parameters for Data Pump Export and Import.
- Export
Directory List<GetObjects Migrations Initial Load Setting Export Directory Object> - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- Handle
Grant stringErrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- Import
Directory List<GetObjects Migrations Initial Load Setting Import Directory Object> - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- Is
Consistent bool - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Is
Ignore boolExisting Objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- Is
Tz boolUtc - Include a statement at the start of the dump to set the time zone to UTC.
- Job
Mode string - Oracle Job Mode
- Metadata
Remaps List<GetMigrations Initial Load Setting Metadata Remap> - Defines remapping to be applied to objects as they are processed.
- Primary
Key stringCompatibility - Primary key compatibility option
- Tablespace
Details List<GetMigrations Initial Load Setting Tablespace Detail> - Migration tablespace settings.
- Compatibilities []string
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- Data
Pump []GetParameters Migrations Initial Load Setting Data Pump Parameter - Optional parameters for Data Pump Export and Import.
- Export
Directory []GetObjects Migrations Initial Load Setting Export Directory Object - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- Handle
Grant stringErrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- Import
Directory []GetObjects Migrations Initial Load Setting Import Directory Object - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- Is
Consistent bool - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Is
Ignore boolExisting Objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- Is
Tz boolUtc - Include a statement at the start of the dump to set the time zone to UTC.
- Job
Mode string - Oracle Job Mode
- Metadata
Remaps []GetMigrations Initial Load Setting Metadata Remap - Defines remapping to be applied to objects as they are processed.
- Primary
Key stringCompatibility - Primary key compatibility option
- Tablespace
Details []GetMigrations Initial Load Setting Tablespace Detail - Migration tablespace settings.
- compatibilities List<String>
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump List<GetParameters Migrations Initial Load Setting Data Pump Parameter> - Optional parameters for Data Pump Export and Import.
- export
Directory List<GetObjects Migrations Initial Load Setting Export Directory Object> - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- handle
Grant StringErrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory List<GetObjects Migrations Initial Load Setting Import Directory Object> - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- is
Consistent Boolean - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore BooleanExisting Objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz BooleanUtc - Include a statement at the start of the dump to set the time zone to UTC.
- job
Mode String - Oracle Job Mode
- metadata
Remaps List<GetMigrations Initial Load Setting Metadata Remap> - Defines remapping to be applied to objects as they are processed.
- primary
Key StringCompatibility - Primary key compatibility option
- tablespace
Details List<GetMigrations Initial Load Setting Tablespace Detail> - Migration tablespace settings.
- compatibilities string[]
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump GetParameters Migrations Initial Load Setting Data Pump Parameter[] - Optional parameters for Data Pump Export and Import.
- export
Directory GetObjects Migrations Initial Load Setting Export Directory Object[] - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- handle
Grant stringErrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory GetObjects Migrations Initial Load Setting Import Directory Object[] - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- is
Consistent boolean - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore booleanExisting Objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz booleanUtc - Include a statement at the start of the dump to set the time zone to UTC.
- job
Mode string - Oracle Job Mode
- metadata
Remaps GetMigrations Initial Load Setting Metadata Remap[] - Defines remapping to be applied to objects as they are processed.
- primary
Key stringCompatibility - Primary key compatibility option
- tablespace
Details GetMigrations Initial Load Setting Tablespace Detail[] - Migration tablespace settings.
- compatibilities Sequence[str]
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data_
pump_ Sequence[Getparameters Migrations Initial Load Setting Data Pump Parameter] - Optional parameters for Data Pump Export and Import.
- export_
directory_ Sequence[Getobjects Migrations Initial Load Setting Export Directory Object] - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- handle_
grant_ strerrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- import_
directory_ Sequence[Getobjects Migrations Initial Load Setting Import Directory Object] - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- is_
consistent bool - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is_
ignore_ boolexisting_ objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is_
tz_ boolutc - Include a statement at the start of the dump to set the time zone to UTC.
- job_
mode str - Oracle Job Mode
- metadata_
remaps Sequence[GetMigrations Initial Load Setting Metadata Remap] - Defines remapping to be applied to objects as they are processed.
- primary_
key_ strcompatibility - Primary key compatibility option
- tablespace_
details Sequence[GetMigrations Initial Load Setting Tablespace Detail] - Migration tablespace settings.
- compatibilities List<String>
- Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- data
Pump List<Property Map>Parameters - Optional parameters for Data Pump Export and Import.
- export
Directory List<Property Map>Objects - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- handle
Grant StringErrors - The action taken in the event of errors related to GRANT or REVOKE errors.
- import
Directory List<Property Map>Objects - Directory object details, used to define either import or export directory objects in Data Pump Settings.
- is
Consistent Boolean - Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- is
Ignore BooleanExisting Objects - Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- is
Tz BooleanUtc - Include a statement at the start of the dump to set the time zone to UTC.
- job
Mode String - Oracle Job Mode
- metadata
Remaps List<Property Map> - Defines remapping to be applied to objects as they are processed.
- primary
Key StringCompatibility - Primary key compatibility option
- tablespace
Details List<Property Map> - Migration tablespace settings.
GetMigrationsInitialLoadSettingDataPumpParameter
- Estimate string
- Estimate size of dumps that will be generated.
- Exclude
Parameters List<string> - Exclude paratemers for Export and Import.
- Export
Parallelism intDegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- Import
Parallelism intDegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- Is
Cluster bool - Set to false to force Data Pump worker process to run on one instance.
- Table
Exists stringAction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- Estimate string
- Estimate size of dumps that will be generated.
- Exclude
Parameters []string - Exclude paratemers for Export and Import.
- Export
Parallelism intDegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- Import
Parallelism intDegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- Is
Cluster bool - Set to false to force Data Pump worker process to run on one instance.
- Table
Exists stringAction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate String
- Estimate size of dumps that will be generated.
- exclude
Parameters List<String> - Exclude paratemers for Export and Import.
- export
Parallelism IntegerDegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism IntegerDegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster Boolean - Set to false to force Data Pump worker process to run on one instance.
- table
Exists StringAction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate string
- Estimate size of dumps that will be generated.
- exclude
Parameters string[] - Exclude paratemers for Export and Import.
- export
Parallelism numberDegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism numberDegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster boolean - Set to false to force Data Pump worker process to run on one instance.
- table
Exists stringAction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate str
- Estimate size of dumps that will be generated.
- exclude_
parameters Sequence[str] - Exclude paratemers for Export and Import.
- export_
parallelism_ intdegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- import_
parallelism_ intdegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is_
cluster bool - Set to false to force Data Pump worker process to run on one instance.
- table_
exists_ straction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
- estimate String
- Estimate size of dumps that will be generated.
- exclude
Parameters List<String> - Exclude paratemers for Export and Import.
- export
Parallelism NumberDegree - Maximum number of worker processes that can be used for a Data Pump Export job.
- import
Parallelism NumberDegree - Maximum number of worker processes that can be used for a Data Pump Import job. For an Autonomous Database, ODMS will automatically query its CPU core count and set this property.
- is
Cluster Boolean - Set to false to force Data Pump worker process to run on one instance.
- table
Exists StringAction - IMPORT: Specifies the action to be performed when data is loaded into a preexisting table.
GetMigrationsInitialLoadSettingExportDirectoryObject
GetMigrationsInitialLoadSettingImportDirectoryObject
GetMigrationsInitialLoadSettingMetadataRemap
- New
Value string - Specifies the new value that oldValue should be translated into.
- Old
Value string - Specifies the value which needs to be reset.
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- New
Value string - Specifies the new value that oldValue should be translated into.
- Old
Value string - Specifies the value which needs to be reset.
- Type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- new
Value String - Specifies the new value that oldValue should be translated into.
- old
Value String - Specifies the value which needs to be reset.
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- new
Value string - Specifies the new value that oldValue should be translated into.
- old
Value string - Specifies the value which needs to be reset.
- type string
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
- new
Value String - Specifies the new value that oldValue should be translated into.
- old
Value String - Specifies the value which needs to be reset.
- type String
- The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.
GetMigrationsInitialLoadSettingTablespaceDetail
- Block
Size stringIn Kbs - Size of Oracle database blocks in KB.
- Extend
Size intIn Mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- Is
Auto boolCreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- Is
Big boolFile - Set this property to true to enable tablespace of the type big file.
- Remap
Target string - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- Target
Type string - Type of Database Base Migration Target.
- Block
Size stringIn Kbs - Size of Oracle database blocks in KB.
- Extend
Size intIn Mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- Is
Auto boolCreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- Is
Big boolFile - Set this property to true to enable tablespace of the type big file.
- Remap
Target string - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- Target
Type string - Type of Database Base Migration Target.
- block
Size StringIn Kbs - Size of Oracle database blocks in KB.
- extend
Size IntegerIn Mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto BooleanCreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big BooleanFile - Set this property to true to enable tablespace of the type big file.
- remap
Target String - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type String - Type of Database Base Migration Target.
- block
Size stringIn Kbs - Size of Oracle database blocks in KB.
- extend
Size numberIn Mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto booleanCreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big booleanFile - Set this property to true to enable tablespace of the type big file.
- remap
Target string - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type string - Type of Database Base Migration Target.
- block_
size_ strin_ kbs - Size of Oracle database blocks in KB.
- extend_
size_ intin_ mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is_
auto_ boolcreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is_
big_ boolfile - Set this property to true to enable tablespace of the type big file.
- remap_
target str - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target_
type str - Type of Database Base Migration Target.
- block
Size StringIn Kbs - Size of Oracle database blocks in KB.
- extend
Size NumberIn Mbs - Size to extend the tablespace in MB. Note: Only applicable if 'isBigFile' property is set to true.
- is
Auto BooleanCreate - Set this property to true to auto-create tablespaces in the target Database. Note: This is not applicable for Autonomous Database Serverless databases.
- is
Big BooleanFile - Set this property to true to enable tablespace of the type big file.
- remap
Target String - Name of the tablespace on the target database to which the source database tablespace is to be remapped.
- target
Type String - Type of Database Base Migration Target.
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
oci
Terraform Provider.