首页 » ORACLE 9i-23c » sqlplus login Error accessing PRODUCT_USER_PROFILE

sqlplus login Error accessing PRODUCT_USER_PROFILE

  • 2011/07/07
  • ORACLE 9i-23c
  • 1,100 views
  • 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.

这个错误发生成手动建库

打赏

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

上一篇：

下一篇：