V7 Compare table data bug

[agent86]

When comparing date columns. If one table has time component and the target does not, comparing table data does not work.

Source
--------------
trunc(sysdate)

target
---------
sysdate

The script generated by comparing misses the time component. The to_date function looks like:

TO_DATE('2006/03/08 ', 'YYYY/MM/DD HH24:MI:SS')

thanks.

 

[Marco Kalter]

We'll fix it.

 

[bcoulam]

If it isn't already in your enhancement list, please include the ability to exclude certain columns from the table compare. Almost all our tables (and many other Oracle shops), have audit trail columns tacked onto the end of every table to track when the row was last modified and who did it. These are instance-specific data items that shouldn't be included in a compare or they will show as differences every time.

Once that is enhanced, this will be a very sweet feature addition for v7 that I didn't even know I needed. Now that I see it, I need it.

Kudos Marco!

bc

 

[Marco Kalter]

This is indeed already on the list of enhancement requests.

 

[agent86]

Also compare data does not work when using timestamp with local time zone datatype. It returns an error saying column is not a date. Can this get fixed please?

thanks

 

[Marco Kalter]

We'll check it out and will fix it.

 

[D.]

Marco,

You mention above that choosing columns is on the list of enhancement requests (back in June 2006). Has any progress been made on this ?

D.

 

[Marco Kalter]

This is still planned for 8.0.