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