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 white space before or after a comma. The default, NULL , indicates that all columns will be compared. |
array_columns
|
A PL/SQL 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. |