You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_COMPARISON


1 to 16 of 16 results.


Database Reference, 12c Release 1 (12.1)

DBA_COMPARISON

4.123 DBA_COMPARISONDBA_COMPARISON displays information about all comparison objects in the database. Related View

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_COMPARISON

ViewsThe DBMS_COMPARISON package uses the following views: DBA_COMPARISON USER_COMPARISON

Database Reference, 12c Release 1 (12.1)

USER_COMPARISON

6.312 USER_COMPARISONcolumns (except for OWNER ) are the same as those in \" DBA_COMPARISON \".

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_COMPARISON

COMPARE Functionis raised. To determine the scan mode for the comparison, query the DBA_COMPARISON data dictionary … is raised. To determine the scan mode for the comparison, query the DBA_COMPARISON data dictionary

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing Information About Comparisons and Comparison ResultsDBMS_COMPARISON package: DBA_COMPARISON USER_COMPARISON DBA_COMPARISON_COLUMNS USER_COMPARISON_COLUMNS

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing General Information About the Comparisons in a DatabaseThe DBA_COMPARISON data dictionary view contains information about the comparisons in the local … , SCHEMA_NAME, OBJECT_NAME, OBJECT_TYPE, SCAN_MODE, DBLINK_NAME FROM DBA_COMPARISON; Your output is

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Parent Scans and Root Scanscolumn in the DBA_COMPARISON data dictionary view. See Also: Oracle Database Reference for

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing Information Specific to Random and Cyclic Comparisons, OBJECT_NAME, OBJECT_TYPE, SCAN_PERCENT, CYCLIC_INDEX_VALUE FROM DBA_COMPARISON WHERE SCAN_PERCENT IS NOT NULL

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

BucketsMIN_ROWS_IN_BUCKET columns in the DBA_COMPARISON data dictionary view. The DBMS_COMPARISON package uses

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing the Parent Scan ID and Root Scan ID for Each Scan in a DatabaseFROM DBA_COMPARISON c, DBA_COMPARISON_SCAN s WHERE c.OWNER = s.OWNER AND c.COMPARISON_NAME

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring an Oracle Streams Environment

Table 22-1 Oracle Streams Static Data Dictionary ViewsDBA_CAPTURE_PREPARED_SCHEMAS N/A ALL_CAPTURE_PREPARED_TABLES DBA_CAPTURE_PREPARED_TABLES N/A N/A DBA_COMPARISON

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing the Columns Compared by Each Comparison in a DatabaseFROM DBA_COMPARISON c, DBA_COMPARISON_COLUMNS o WHERE c.OWNER = o.OWNER AND c.COMPARISON_NAME

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing Detailed Information About the Row Differences Found in a ScanDBA_COMPARISON c, DBA_COMPARISON_SCAN s WHERE c.COMPARISON_NAME = s.COMPARISON_NAME AND c.OWNER

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_COL_PRIVS 4.121 DBA_COLL_TYPES 4.122 DBA_COMMON_AUDIT_TRAIL 4.123 DBA_COMPARISON 4.124

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

To compare the entire hr.departments table at the ii1.example.com and ii2.example.com databases: SELECT c.OWNER, c.COMPARISON_NAME, c.SCHEMA_NAME, c.OBJECT_NAME, s.CURRENT_DIF_COUNT FROM DBA_COMPARISON

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Comparing and Converging Data

Viewing General Information About Each Scan in a DatabaseDBA_COMPARISON c, DBA_COMPARISON_SCAN s WHERE c.OWNER = s.OWNER AND c.COMPARISON_NAME = s.COMPARISON_NAME