Ability to select same schema as source and target specify scn or flashback time of both
Oracle has a feature called flashback query/schema that allows you to view a table/schema as of a particular timestamp. For some projects, there is a need to identify all the tables inserted/updated/deleted by a particular application process.
This would be an additional use case for Data Compare if it checked if flashback was enabled on the source and target schemas and allowed specifying a time.
Then it could be used for my use case - i.e. identifying what impact a particular front end screen or batch process had on the database.
It could also be used after a major incident as an alternative to a full backup e.g. user deletes lots of data they didnt intend to from a test system and data compare could be used to create a fix script to flash back (using where clause by username on the relevant tables)
This could be mimicked today by creating a new schema as a copy of the exiting but that requires double the database space to hold the copy and a process to make the copy. Using flashback would mean no preparation to do the compare and making use of a great Oracle feature to enhance Redgate Data Compare.