Re: Request for test help

On Jul 14, 3:26 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Frank van Bortel wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
>
> > Windows 32-bit, 10.2.0.3.0 + latest CPU patch - same:
> > SQL> SELECT dbms_undo_adv.undo_advisor(35,44,1) from dual;
> > SELECT dbms_undo_adv.undo_advisor(35,44,1) from dual
> > *
> > ERROR at line 1:
> > ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
> > ORA-06512: at "SYS.PRVT_ADVISOR", line 3895
> > ORA-14551: cannot perform a DML operation inside a query
> > ORA-06512: at "SYS.DBMS_UNDO_ADV", line 703
> > ORA-06512: at "SYS.DBMS_UNDO_ADV", line 752
>
> > That should be enough environments not to make it
> > a platform dependent bug.
>
> > Could give you same version on HP-UX Itaniuum if wanted.
>
> > - --
> > Regards,
> > Frank van Bortel
>
> > Top-posting is one way to shut me up...
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.1 (MingW32)
>
> > iD8DBQFGmLbwLw8L4IAs830RAv37AJ9MTurdEJHRI8RcuMGsHPy0ThWYggCfWjlW
> > JGtrgpBdtkvSos4HJoC2BlI=
> > =BYV0
> > -----END PGP SIGNATURE-----
>
> Thanks but I think that does it unless someone has 10gR1 anywhere?
> My suspicion is that it never worked in any version on any platform.
>
> Thanks again everyone.

Yep, 2 sub-versions of 10gR1 here, both on Linux for zSeries (under zVM), so a little exotic ;-)
Results:

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SELECT dbms_undo_adv.undo_advisor(14991, 15161, 1) FROM dual; SELECT dbms_undo_adv.undo_advisor(14991, 15161, 1) FROM dual

       *
ERROR at line 1:
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

ORA-06512: at "SYS.PRVT_ADVISOR", line 3658
ORA-14551: cannot perform a DML operation inside a query
ORA-06512: at "SYS.DBMS_UNDO_ADV", line 703
ORA-06512: at "SYS.DBMS_UNDO_ADV", line 752

Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> SELECT dbms_undo_adv.undo_advisor(8558, 8759, 1) FROM dual; SELECT dbms_undo_adv.undo_advisor(8558, 8759, 1) FROM dual

       *
ERROR at line 1:
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

ORA-06512: at "SYS.PRVT_ADVISOR", line 3658
ORA-14551: cannot perform a DML operation inside a query
ORA-06512: at "SYS.DBMS_UNDO_ADV", line 703
ORA-06512: at "SYS.DBMS_UNDO_ADV", line 752

HTH

--
Jeroen