18
DBMS_RECTIFIER_DIFF

"DIFFERENCES Procedure"

Determines the differences between two tables.

"RECTIFY Procedure"

Resolves the differences between two tables.

sname1

Name of the schema at reference_site.

oname1

Name of the table at reference_site.

reference_site

Name of the reference database site. The default, NULL, indicates the current site.

sname2

Name of the schema at comparison_site.

oname2

Name of the table at comparison_site.

comparison_site

Name of the comparison database site. The default, NULL, indicates the current site.

where_clause

Only rows satisfying this clause are selected for comparison. The default, NULL, indicates all rows are compared.

column_list

A comma-separated list of one or more column names being compared for the two tables. You must not have any spaces before or after a comma. The default, NULL, indicates that all columns will be compared.

array_columns

A PL/SQL index-by table of column names being compared for the two tables. Indexing begins at 1, and the final element of the array must be NULL. If position 1 is NULL, then all columns are used.

missing_rows_sname

Name of the schema containing the tables with the missing rows.

missing_rows_oname1

Name of an existing table at missing_rows_site that stores information about the rows in the table at reference_site that are missing from the table at comparison_site, and information about the rows at comparison_site site that are missing from the table at reference_site.

missing_rows_oname2

Name of an existing table at missing_rows_site that stores information about the missing rows. This table has three columns: the R_ID column shows the rowid of the row in the missing_rows_oname1 table, the PRESENT column shows the name of the site where the row is present, and the ABSENT column shows name of the site from which the row is absent.

missing_rows_site

Name of the site where the missing_rows_oname1 and missing_rows_oname2 tables are located. The default, NULL, indicates that the tables are located at the current site.

max_missing

Integer that specifies the maximum number of rows that should be inserted into the missing_rows_oname table. If more than max_missing rows are missing, then that many rows are inserted into missing_rows_oname, and the routine then returns normally without determining whether more rows are missing. This parameter is useful if the fragments are so different that the missing rows table has too many entries and there is no point in continuing. Raises exception badnumber if max_missing is less than 1 or NULL.

commit_rows

Maximum number of rows to insert to or delete from the reference or comparison table before a COMMIT occurs. By default, a COMMIT occurs after 500 inserts or 500 deletes. An empty string (' ') or NULL indicates that a COMMIT should be issued only after all rows for a single table have been inserted or deleted.

nosuchsite

Database site could not be found.

badnumber

The commit_rows parameter is less than 1.

missingprimarykey

Column list must include primary key (or SET_COLUMNS equivalent).

badname

NULL or empty string for table or schema name.

cannotbenull

Parameter cannot be NULL.

notshapeequivalent

Tables being compared are not shape equivalent. Shape refers to the number of columns, their column names, and the column datatypes.

unknowncolumn

Column does not exist.

unsupportedtype

Type not supported.

dbms_repcat.commfailure

Remote site is inaccessible.

dbms_repcat.missingobject

Table does not exist.

sname1

Name of the schema at reference_site.

oname1

Name of the table at reference_site.

reference_site

Name of the reference database site. The default, NULL, indicates the current site.

sname2

Name of the schema at comparison_site.

oname2

Name of the table at comparison_site.

comparison_site

Name of the comparison database site. The default, NULL, indicates the current site.

column_list

A comma-separated list of one or more column names being compared for the two tables. You must not have any spaces before or after a comma. The default, NULL, indicates that all columns will be compared.

array_columns

A PL/SQL index-by table of column names being compared for the two tables. Indexing begins at 1, and the final element of the array must be NULL. If position 1 is NULL, then all columns are used.

missing_rows_sname

Name of the schema containing the tables with the missing rows.

missing_rows_oname1

Name of the table at missing_rows_site that stores information about the rows in the table at reference_site that are missing from the table at comparison_site, and information about the rows at comparison_site that are missing from the table at reference_site.

missing_rows_oname2

Name of the table at missing_rows_site that stores information about the missing rows. This table has three columns: the rowid of the row in the missing_rows_oname1 table, the name of the site at which the row is present, and the name of the site from which the row is absent.

missing_rows_site

Name of the site where the missing_rows_oname1 and missing_rows_oname2 tables are located. The default, NULL, indicates that the tables are located at the current site.

commit_rows

Maximum number of rows to insert to or delete from the reference or comparison table before a COMMIT occurs. By default, a COMMIT occurs after 500 inserts or 500 deletes. An empty string (' ') or NULL indicates that a COMMIT should be issued only after all rows for a single table have been inserted or deleted.

nosuchsite

Database site could not be found.

badnumber

The commit_rows parameter is less than 1.

badname

NULL or empty string for table or schema name.

dbms_repcat.commfailure

Remote site is inaccessible.

dbms_repcat.missingobject

Table does not exist.