You need to execute the script pupbld.sql. You can find this script in
$ORACLE_HOME/RDBMS/ADMIN directory. You need to run this script in SYSTEM
account.
--
Vijaya Kumar Vardhineni
Oracle DBA, EDS
Plano, TX
Frantisek Jancus <fjancus_at_iss.cz> wrote in article
<32CCD541.3F7F_at_iss.cz>...
> Hi,
> I have a problem. I had one database on Oracle7 Server and then I
> created a new database. I tried to connect to the new database in
> SQL*PLus and I got the message error:
>
> Warning: Product user profile information not loaded!
> ERROR:
> ORA-00942: table or view does not exist
>
> Error in disabling roles in product user profile.
>
> Connected to:
> Oracle7 Server Release 7.2.2.4.0 - Production Release
> With the distributed and parallel query options
> PL/SQL Release 2.2.2.3.0 - Production
> SQL>
>
> If I connect as SYSTEM user then this error does not issues but if I
> connect as the other user (SYS, ...) then it does. We have Oracle7
> Server Release 7.2.2.4.0 on HP-UX. I can't find what this error caused.
>
> Can anybody help me? Thank You.
>
> ------------------
> Frantisek Jancus
> ISS Brno, CZ
> fjancus_at_iss.cz
> ------------------
>
Received on Fri Jan 03 1997 - 00:00:00 CST
