OracleDataVerificationTableRowCountSummary

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

Bases: DataVerificationTableRowCountSummary

Table row count comparison result line for Oracle migrations.

Attributes:

DATABASE_COMBINATION_MYSQL

A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary.

DATABASE_COMBINATION_ORACLE

A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary.

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'

A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary. This constant has a value of “MYSQL”

DATABASE_COMBINATION_ORACLE = 'ORACLE'

A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary. This constant has a value of “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.

property 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.

property 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

property 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

property table_name

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

Returns

The table_name of this DataVerificationTableRowCountSummary.

Return type

str

property 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

property 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

property 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

property 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