Request for test help

Can anyone get this to work in any version of 10gR1 or 10gR2?

col instart_fmt noprint;
col inst_name format a12 heading 'Instance'; col db_name format a12 heading 'DB Name'; col snap_id format 99999990 heading 'Snap Id'; col snapdat format a18 heading 'Snap Started' just c; col lvl format 99 heading 'Snap|Level';
set heading on;
break on inst_name on db_name on host on instart_fmt skip 1; ttitle off;

SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT, di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID, TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT, s.snap_level LVL
FROM dba_hist_snapshot s, dba_hist_database_instance di WHERE di.dbid = s.dbid
AND di.instance_number = s.instance_number AND di.startup_time = s.startup_time
ORDER BY snap_id;

SELECT dbms_undo_adv.undo_advisor(<starting_snap_id, <ending_snap_id>, 1) FROM dual;

For example:

SELECT dbms_undo_adv.undo_advisor(587, 600, 1) FROM dual;

If you do not have a license to access the two dba_hist tables please do not do so at your employer's expense.

I would like to know the exact version number of 4 decimal places and whether it succeeds or fails. Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org