addmComparePeriodOrDb.sql

-- addmComparePeriodOrDb.sql
-- Brian Fitzgerald

SET pagesize 0
SET linesize 32767
SET trimspool ON
SET LONG 100000

variable rpt clob
COLUMN rpt format a60000

COLUMN spoolfile new_value spoolfile format a80
SELECT 'addmrpt.' || instance_name || '.' || TO_CHAR(SYSDATE, 'yyyymmdd.hhmiss') || '.html' spoolfile FROM v$instance;

spool &&spoolfile

SELECT dbms_addm.compare_databases (base_dbid            => NULL,
                                    base_begin_snap_id   => 314,
                                    base_end_snap_id     => 315,
                                    comp_dbid            => NULL,
                                    comp_begin_snap_id   => 315,
                                    comp_end_snap_id     => 316,
                                    report_type          => 'HTML') rpt
  FROM dual;
spool off

prompt created FILE:
prompt &&spoolfile
quit