Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Schema Manager and sequences (bug?)

Schema Manager and sequences (bug?)

From: H. John C. Hopkins <john_nospam_at_hpe.ufl.edu>
Date: 1998/05/11
Message-ID: <6j6vtk$f4s@no-names.nerdc.ufl.edu>#1/1

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 Received on Mon May 11 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US