Re: Newbie, SQLPLUS problem!

Brian Spears wrote:
>
> Nabil Courdy wrote:
> >
> > I have installed Oracle 7.3. Installation was smooth.
> > The database was created smoothly as well. Now, I am
> > ready to use SQL. However, SQLPLUS gave me the
> > following problem-:
> >
> > . It recommended running some script called pup(something).sql
> > which when I ran complained about the creation of some views
> > and tables.
> >
> > Am I missing something? I am without documentation, but I've
> > got some non-ORACLE books that have been very helpful in
> > presenting the architecture of ORACLE. Now, however, I need
> > specifics.
> >
> > TIA
> >
> > Nabil
> > ====--------------------------------------------------------------------
>
> Hi TIA,
>
> This pupbld is in the oracle sqlplus/admin directory. It sets up
> some stuff needed for sql roles. You should run this as the user
> sys. It probably didn't work because you had connect as another
> user. Go look at the sysnonyms etc it was suppose to create. Drop
> the public synonyms etc that you created as the other user. Then
> go back and run the script as SYS. The message you see when
> you sign on to SQLPLUS will go away when you run the pupbld
> properly.
>
> Cheers,
> Brian Spears
> ORACLE DBA,
> DYNAPRO, BC. CANADA

Very good advice except you should run it as SYSTEM. It's one of the few which SYSTEM must run as this is to create some SQL*Plus tool tables.

Sylvie Bérubé
sberube_at_cam.org Received on Thu Jan 30 1997 - 00:00:00 CST