Compare table data with different table name

[DLGL]

Hi,

Is it possible to compare the data of two tables in the same database (or other) with different names.

Ex: TABLE_T and TABLE_BACKUP_20060202_T

The two tables has the same description.

I know MINUS could do the job but I like the output of the compare tables data tool.

Thank you !

 

[Marco Kalter]

This is currently not possible, you can only compare the same table in different schema's.

 

[F. van Boven]

Can this be made possible?

We want to compare data after a major stored procedure is finished. Now we backup the data in a table, export the data from the table into another database instance, rename it to the original and perform the compare...

If there is lot's of data, this takes quite a while

 

[DLGL]

Hi,

To compare 2 tables form the same db, we finaly use CompareData software. zidsoft.com, I don't find it really easy to understand but when installed correctly it does a great job.

For sure I would prefer using Pl/Sql Developer directly to perform the task.

 

[ScottMattes]

select *
from my_table

minus

select *
from my_table as of timestamp( );

you might need bigger system areas to hold all the data for massive changes, but...