Re: Schema Manager and sequences (bug?)
Date: 1998/05/11
Message-ID: <35574b90.4587887_at_newshost.us.oracle.com>#1/1
John,
It is true....with Oracle Enterprise Manager's Schema Manager tool, version 1.2, a sequence would increment by the defined interval when selected.
This is a software defect (i.e., bug) that has been corrected in version 1.4 of OEM Schema Manager.
On Mon, 11 May 1998 09:52:32 -0400, "H. John C. Hopkins" <john_nospam_at_hpe.ufl.edu> wrote:
>OEM 1.2.2
>Oracle 7.3
>
>I notice that schema manager increments the value of my sequences when I
>select a particular sequence, de-select it (by selecting another sequence to
>view), and select it again.
>
>Surely Schema Manager pulls its data from a data dictionary view, so why the
>increase in the sequence? Is it making calls to nextval? That would be...
>well, stupid. So I have to wonder what's going on.
>
>Meanwhile, I'm sticking with T.O.A.D.
>
>Thanks for any insight.
>
>-John C. Hopkins
>Programmer/Analyst
>
>
>
>
>
Thanks!
Joel
Joel R. Kallman Oracle Government, Education, & Health
Columbus, OH http://govt.us.oracle.com jkallman_at_us.oracle.com http://www.oracle.com
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon May 11 1998 - 00:00:00 CEST