OracleDataVerificationTableRowCountSummary¶

class oci.database_migration.models.OracleDataVerificationTableRowCountSummary(**kwargs)¶

Bases: oci.database_migration.models.data_verification_table_row_count_summary.DataVerificationTableRowCountSummary

Table row count comparison result line for Oracle migrations.

Attributes

`DATABASE_COMBINATION_MYSQL`	str(object=’’) -> str
`DATABASE_COMBINATION_ORACLE`	str(object=’’) -> str
`database_combination`	[Required] Gets the database_combination of this DataVerificationTableRowCountSummary.
`owner`	Gets the owner of this DataVerificationTableRowCountSummary.
`source_row_count`	[Required] Gets the source_row_count of this DataVerificationTableRowCountSummary.
`table_name`	[Required] Gets the table_name of this DataVerificationTableRowCountSummary.
`target_row_count`	[Required] Gets the target_row_count of this DataVerificationTableRowCountSummary.
`time_last_source_statistics_collection`	[Required] Gets the time_last_source_statistics_collection of this OracleDataVerificationTableRowCountSummary.
`time_last_target_statistics_collection`	[Required] Gets the time_last_target_statistics_collection of this OracleDataVerificationTableRowCountSummary.
`variance_percent`	[Required] Gets the variance_percent of this DataVerificationTableRowCountSummary.

Methods

`__init__`(**kwargs)	Initializes a new OracleDataVerificationTableRowCountSummary object with values from keyword arguments.
`get_subtype`(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

DATABASE_COMBINATION_MYSQL = 'MYSQL'¶

DATABASE_COMBINATION_ORACLE = 'ORACLE'¶

__init__(**kwargs)¶

Initializes a new OracleDataVerificationTableRowCountSummary object with values from keyword arguments. The default value of the database_combination attribute of this class is ORACLE and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

database_combination (str) – The value to assign to the database_combination property of this OracleDataVerificationTableRowCountSummary. Allowed values for this property are: “MYSQL”, “ORACLE”
owner (str) – The value to assign to the owner property of this OracleDataVerificationTableRowCountSummary.
table_name (str) – The value to assign to the table_name property of this OracleDataVerificationTableRowCountSummary.
source_row_count (int) – The value to assign to the source_row_count property of this OracleDataVerificationTableRowCountSummary.
target_row_count (int) – The value to assign to the target_row_count property of this OracleDataVerificationTableRowCountSummary.
variance_percent (float) – The value to assign to the variance_percent property of this OracleDataVerificationTableRowCountSummary.
time_last_source_statistics_collection (datetime) – The value to assign to the time_last_source_statistics_collection property of this OracleDataVerificationTableRowCountSummary.
time_last_target_statistics_collection (datetime) – The value to assign to the time_last_target_statistics_collection property of this OracleDataVerificationTableRowCountSummary.

database_combination¶

[Required] Gets the database_combination of this DataVerificationTableRowCountSummary. 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.

Allowed values for this property are: “MYSQL”, “ORACLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The database_combination of this DataVerificationTableRowCountSummary.
Return type:	str

static get_subtype(object_dictionary)¶: Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

owner¶

Gets the owner of this DataVerificationTableRowCountSummary. Schema/owner name.

This field is omitted (null/empty depending on backend serialization) for database-wide object types that are not schema-scoped.

Oracle non-schema-scoped object types: USER, ROLE, PROFILE, TABLESPACE, DATABASE_LINK, CONTROLFILE, DATAFILE, REDO_LOG, DIRECTORY, LIBRARY, CONTEXT.

MySQL non-schema-scoped object types: USER, ROLE, SERVER, TABLESPACE, LOGFILE_GROUP.

Returns:	The owner of this DataVerificationTableRowCountSummary.
Return type:	str

source_row_count¶

[Required] Gets the source_row_count of this DataVerificationTableRowCountSummary. Row count in source.

Returns:	The source_row_count of this DataVerificationTableRowCountSummary.
Return type:	int

table_name¶

[Required] Gets the table_name of this DataVerificationTableRowCountSummary. Table name.

Returns:	The table_name of this DataVerificationTableRowCountSummary.
Return type:	str

target_row_count¶

[Required] Gets the target_row_count of this DataVerificationTableRowCountSummary. Row count in target.

Returns:	The target_row_count of this DataVerificationTableRowCountSummary.
Return type:	int

time_last_source_statistics_collection¶

[Required] Gets the time_last_source_statistics_collection of this OracleDataVerificationTableRowCountSummary. Time of last statistics collection in the source used for the dictionary-based row count estimate. This value is reported per row because statistics can be collected at different times per object. This timestamp is stored in UTC.

Returns:	The time_last_source_statistics_collection of this OracleDataVerificationTableRowCountSummary.
Return type:	datetime

time_last_target_statistics_collection¶

[Required] Gets the time_last_target_statistics_collection of this OracleDataVerificationTableRowCountSummary. Time of last statistics collection in the target used for the dictionary-based row count estimate. This value is reported per row because statistics can be collected at different times per object. This timestamp is stored in UTC.

Returns:	The time_last_target_statistics_collection of this OracleDataVerificationTableRowCountSummary.
Return type:	datetime

variance_percent¶

[Required] Gets the variance_percent of this DataVerificationTableRowCountSummary. Percentage variance between source and target row counts. This value is expected to be non-negative.

A negative value indicates that the target has rows not present in the source, which should be treated as an inconsistency (i.e., a failed comparison/report result).

Returns:	The variance_percent of this DataVerificationTableRowCountSummary.
Return type:	float