Bernhard S
Member³
In v10 as well as in v9 PL/SQL Developer currently the header of the differences tab result looks like this:
I would like more metadata of the comparison to be added here. I need both, the connected SRC/TGT-user as well as the SRC/TGT compared schema user, as you might not see every object while connected as a different user than the schema user you use for comparison. I also need info whether all objects were compared or a subselection. It would be good if the numbers of compared tables/views/... could be listed here as well as the numbers of tables/views/... where differences have been found and/or which do not yet exist on target side at all. I also would like to have the exact (down to seconds) start and end date/time of the comparison here and the calculated duration out of that.
SQL:
rem Differences between SRC_SCHEMA@SRC_TNS_NAME and TGT_SCHEMA@TGT_TNS_NAME, created on 21.03.2013
rem Press Apply button, or run in Command Window or SQL*Plus connected as TGT_SCHEMA@TGT_TNS_NAMEI would like more metadata of the comparison to be added here. I need both, the connected SRC/TGT-user as well as the SRC/TGT compared schema user, as you might not see every object while connected as a different user than the schema user you use for comparison. I also need info whether all objects were compared or a subselection. It would be good if the numbers of compared tables/views/... could be listed here as well as the numbers of tables/views/... where differences have been found and/or which do not yet exist on target side at all. I also would like to have the exact (down to seconds) start and end date/time of the comparison here and the calculated duration out of that.
