dbForge Data Compare for Oracle is a powerful, fast, and easy-to-use tool for Oracle database comparison and synchronization. It helps you quickly compare data in two or more tables, find the differences at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface.

KEY FEATURES:
1) Wide support for Oracle server versions and objects to be compared:
* Support for all Oracle versions, from 8i to 12c
* Can work without Oracle client (Oracle Direct connection)
* Working with Oracle on Amazon RDS
* Compare and synchronize data in tables, views, materialized views, custom queries, multiple Oracle schemas
* Compare databases with different structures
2) Comparison and synchronization options:
* Include tables or views into comparison by mask or individually
* Exclude objects from comparison by mask or individually
* Ignore columns by mask
* Float types rounding option
* Ignore Case and Ignore Trailing Spaces options for string comparison
3) Data comparison and analysis:
* Filter and sort objects in result
* View data differences for each pair of objects
* Perform full-text search in data differences
* View number of changes per column
* Hide unmodified columns to simplify analysis
* Generate data comparison report in Excel and HTML formats
* Include actual data into report
* Report on selected objects only
4) Automate routine tasks
* Save comparison project settings for future use
* Save settings to a command line arguments file
* Compare data
* Multiple ways to sync data
* Generate data report
* Execute and format script
5) Sync data
* Multiple ways to sync data: create and open, execute, save synchronization script
* Migrate individual records, groups of records, or all data differences
* Toggle synchronization direction to apply data changes to both databases
* Rollback changes on error
* Synchronize LOBs via files
* Warnings on possible problems prior to synchronization