首页 » ORACLE » sqlplus login Error accessing PRODUCT_USER_PROFILE

sqlplus login Error accessing PRODUCT_USER_PROFILE

SQL> conn zwz/zwz;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user
USER is “ZWZ”
SQL> conn / as sysdba
Connected.
SQL> desc product_user_profile;
ERROR:
ORA-04043: object product_user_profile does not exist

SQL> conn system/manager
Connected.
SQL> @?/sqlplus/admin/pupbld.sql

SQL> conn zwz/zwz
Connected.
SQL> desc product_user_profile;
Name Null? Type
—————————————– ——– —————————-
PRODUCT NOT NULL VARCHAR2(30)
USERID VARCHAR2(30)
ATTRIBUTE VARCHAR2(240)
SCOPE VARCHAR2(240)
NUMERIC_VALUE NUMBER(15,2)
CHAR_VALUE VARCHAR2(240)
DATE_VALUE DATE
LONG_VALUE LONG

pupbld.sql作用

Script to install the SQL*Plus PRODUCT_USER_PROFILE tables. These
— tables allow SQL*Plus to disable commands per user. The tables
— are used only by SQL*Plus and do not affect other client tools
— that access the database. Refer to the SQL*Plus manual for table
— usage information.

这个错误发生成手动建库

打赏

对不起,这篇文章暂时关闭评论。