Newsgroups: comp.databases
Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sdd.hp.com!decwrl!fernwood!oracle!news
From: sharnyo@chez.us.oracle.com (Andi Harnyo)
Subject: Re: Oracle on SCO Unix
Message-ID: <1991Apr10.230231.18585@oracle.com>
Organization: Oracle Corporation
References: <1991Apr9.171917.12335@eng.ufl.edu>
Date: Wed, 10 Apr 91 23:02:31 GMT

In article <1991Apr9.171917.12335@eng.ufl.edu> mjw@wasp.eng.ufl.edu (Michael J. Wohlgemuth) writes:
>I have just completed installing Oracle 6.0.30.3 on SCO
>Unix 3.2.  The install gave no error messages, and I am
>able to start Oracle just fine.  The problem is that some
>of the data dictionary views that certain applications 
>require are missing (namely, USER_USERS).  I am at a loss 
>to figure out what is going on.  I would really appreciate 
>any pointers to solutions to this problem.
>
>Thanks,
>Mike


Mike,


USER_USERS is a view. It is created by running the $ORACLE_HOME/rdbms/admin/catalog.sql
script. If you use the oracle.install script, then you should have it. 
The solution is to rerun the catalog.sql while connected as sys.


-Andi