I am trying to generate a diff report that i imported from another instance.
I am able to force an ugly html by coping an output from the package
set lines 600
set pages 10000
when trying to use the tool in Toad you can only edit the query in the Starting Snapshot, and have to remove WHERE dbid = :dbid, AND instance_number = 1to display the other snapshots. Also if in a PDB you have to change CDB_HIST_SNAPSHOT to DBA_HIST_SNAPSHOT .
You also cant change the instance.
Am i missing a setting somewhere to allow for this compare?