Re: Request for test help

On Jul 13, 6:43 pm, DA Morgan <damor..._at_psoug.org> wrote:
> StefanKapitza wrote:
> > On Jul 13, 11:54 pm, DA Morgan <damor..._at_psoug.org> wrote:
> >> 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
> >> damor..._at_x.washington.edu (replace x with u to respond)
> >> Puget Sound Oracle Users Groupwww.psoug.org
>
> > Failing with Ora-14552
>
> > Windows x84 10.2.0.3.0
> > Centos x64 10.2.0.2.0
> > Centos x86 10.2.0.3.0
>
> > regards
>
> > s.kapitza
>
> I had a feeling thanks. Does anyone have a version where it works?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Probably will be fixed in the next release maybe. Fails on hpux pa risc 10.2.0.3

If you have a reproducible test case then submit an sr if you have access to a support contract. Received on Fri Jul 13 2007 - 19:58:17 CDT