Newsgroups: comp.databases.oracle.misc
Subject: Re: "Product user profile information not loaded"? Why?
References: <19970311204400.PAA12923@ladder01.news.aol.com>

josephs221@aol.com (JosephS221) writes:

>I just created a new database under Oracle 7.2.3 on an AT&T 3000 box.
>When I set it as my ORACLE_SID, and invoke SQL*PLUS, I get the above
>message. It also messages me that:
>Table or view does not exist.
>Error in disabling roles in product user profile.
>What did I do wrong, and how do I fix it? Thanks in advance for your help!

Joseph,

The PRODUCT_USER_PROFILE table does not exist. You need to create it by
running the "pupbld.sql" file. It appears in the
$ORACLE_HOME/sqlplus/admin directory. You need to run this as the SYSTEM
user. This should be run during all database creations.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 50+ technical tips, visit my Web Page:                    <->
<->             www.arikaplan.com                                 <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page aplan's Home Page