-
Title
How do you delete compare logs? -
Description
How to delete old compare logs?
-
Cause
Show compare shows a lot of old compare information which is irrelevent.
-
Resolution
RESOLUTION 1:
Use the remove log compare command to remove compare reports and compare logs
generated by the compare config and compare table commands.Use this commandfrom sp_ctrl
sp_ctrl>remove log compare
Other available options.
remove log compare {id id_number | all | table owner.table_name}
id id_number : Use this option to remove the compare report(s) and log files for a specific compare session.
table owner.table_name Use this option to remove the compare reports and logs for all compare processes that originated on the local system for a specific table.
RESOLUTION 2:
You can remove the old compare logs manually.They are located in the $SP_SYS_VARDIR/log directory.
Thefiles are of the format *desvr* on the source, *declt*and the corresponding *.sql files on the target.