Re: View DBA_USERS Oracle 8.0.5

Kekko, if you do a select count(*) from sys.dual and get > 1 row then you should delete all but one row from dual. We had that happen once and discovered we had a system.dual and a sys.dual, at least one of which had two rows which was causing a problem in Forms. We dropped system.dual; made sure sys.dual had one row, and pointed the public synonym to it and Forms was OK. Both Forms and pl/sql make heavy use of the dual table. We never did learn how we got the system.dual table out there, but the problem has not re-occurred.

In article <3767403E.13E1D3A_at_adr.it>,
  Kekko <dini.f_at_adr.it> wrote:
> I have the same catalog.sql you write.
> It isn't a terminal problem because I note this problem while Designer
> 2000 was reconciling its objects and than I found that it was failed
> because the simple query
> select user from dual founded two values.
> The same strange behaviour (duplicated rows) there is also with
SQLPlus
> and SQLWorksheet.
> Kekko
>
> markp7832_at_my-deja.com wrote:
>
> > In article <37668867.BB8BCEA8_at_adr.it>,
> > Kekko <dini.f_at_adr.it> wrote:
> > > I have a problem with this view: it has duplicated rows!
> > > I have rebuilded the view (from catalog.sql) but the problem is
not
> > > changed.
> > > Can something help me?
> > > Thanks
> > > Kekko
> > >
> > The view DBA_USERS appears fine on our platform, Sequent, ver.
8.0.5.
> > Are you sure it is not some type of terminal display problem? Here
is
> > the sql from catalog.sql for comparision. Good Luck.
> >
> > create or replace view DBA_USERS
> > (USERNAME, USER_ID, PASSWORD, ACCOUNT_STATUS, LOCK_DATE,
> > EXPIRY_DATE,
> > DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, CREATED, PROFILE,
> > EXTERNAL_NAME)
> > as
> > select u.name, u.user#, u.password,
> > m.status,
> > decode(u.astatus, 4, u.ltime,
> > 5, u.ltime,
> > 6, u.ltime,
> > 8, u.ltime,
> > 9, u.ltime,
> > 10, u.ltime, NULL),
> > decode(u.astatus,
> > 1, u.exptime,
> > 2, u.exptime,
> > 5, u.exptime,
> > 6, u.exptime,
> > 9, u.exptime,
> > 10, u.exptime,
> > decode(u.ptime, '', NULL,
> > decode(pr.limit#, 2147483647, NULL,
> > decode(pr.limit#, 0,
> > decode(dp.limit#, 2147483647, NULL, u.ptime +
> > dp.limit#/86400),
> > u.ptime + pr.limit#/86400)))),
> > dts.name, tts.name, u.ctime, p.name, u.ext_username
> > from sys.user$ u, sys.ts$ dts, sys.ts$ tts, sys.profname$ p,
> > sys.user_astatus_map m, sys.profile$ pr, sys.profile$ dp
> > where u.datats# = dts.ts#
> > and u.resource$ = p.profile#
> > and u.tempts# = tts.ts#
> > and u.astatus = m.status#
> > and u.type# = 1
> > and u.resource$ = pr.profile#
> > and dp.profile# = 0
> > and dp.type#=1
> > and dp.resource#=1
> > and pr.type# = 1
> > and pr.resource# = 1
> > /
> >
> > --
> > Mark D. Powell -- The only advice that counts is the advice that
> > you follow so follow your own advice --
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 16 1999 - 07:54:37 CDT