Re: help with an error message

It nags because it is missing a table in system. Run the pupbld.sql script, it is in $ORACLE_HOME/sqlplus/admin (top of my head). It DOES exist! Once you have done that the warning (it's not an error) will go away.

Hth,

--
Sybrand Bakker, Oracle DBA
Legend <legend_at_spacelab.net> wrote in message news:8kPf4.27520$W2.386694_at_iad-read.news.verio.net...
> Hello all,
>
> I am just starting learning Oracle. I finished installing oracle and
created
> a user. When I login as the user from sqlplus, I got such an error and I
> have no idea why. Neither could I find any pupbld.sql in
> $ORACLE_HOME/rdbms/admin/.
>
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
>
> Could someone tell me what I need to do what I create a user? All I did
was:
> grant connect,resource to user1 identified by usrpasswd;
>
> Please correct me if I am wrong? I ran catalog.sql and catproc.sql as user
> internal. Is that a problem? Should I be using system user instead?
>
>
> Regards,
>
>
> Benny
>
>
>
>
>
>
Received on Sat Jan 15 2000 - 00:39:01 CST