Re: View DBA_USERS Oracle 8.0.5

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.
Received on Wed Jun 16 1999 - 01:12:14 CDT