Project automatically picking up a renamed table?

monolith

I am using data compare for Oracle 6.0.23.1366. I have created a project, selected the two databases (which happen to be clones restored from the same snapshot) and selected a subset of tables for the tool to compare - about 10 tables from the 100 in the database. Then saved the project. The project runs fine via execution in the gui and via a batch file - comparing only the tables it has been configured to compare. We have been running this process happily once a day for awhile.

Then, one day, our DBA renamed an unrelated table in the database in preparation for deletion of this table. The clone process restored the two databases for comparison which now included the renamed table. The next run of DataCompare picked up this renamed table and compared it - even though it was not saved as part of the saved project configuration.

The table being deleted was huge and the resultant compare blew the disk on the server.

Is this a known issue with the product and is there a way to prevent this behaviour?

Kurt_M

Hi @monolith

There is a behavior option in Schema Compare for Oracle to detect renamed columns.
 

 
However the above option is not available in Data Compare for Oracle.

If you are comparing from script files, it is possible that the files still have reference to the old table / column names. It might be worth re-creating these if changes, such as the renamed table, occur again in the future. Likewise, it might be worth setting up a new project just in case of these references.