PowerDIFF for Oracle is a carefully designed, powerful and easy to use schema comparison tool for Oracle databases which allows both comparisons and diff-and-merge operations. Output is done visually or as a SQL difference script. The difference script can be applied to one of the databases to sync it to the other one. Both structural and data comparisons can be done - between two database schemas or between a number of preselectable individual database objects. Thus a lot of very individual compare operations are possible. The following objects can be compared to each other: structure of tables (columns, constraints, defaults), data of tables (with WHEREs and almost all data types), indexes (columns and types), constraints (PK, FK and check constraints), views (source code and data), procedures and functions (source code and status), trigger (columns, source code and status), user, roles, privileges - and also database instance parameter and metadata (storage/size parameter, cache...