Jeroen van den Broek wrote:
> 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
Brilliant ... 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
Received on Mon Jul 16 2007 - 08:57:09 CDT
