Error accessing PRODUCT_USER_PROFILE

2017-3-7来源:SQL技巧人气:349



Oracle 10g ,创建完用户之后报warning

SQL> conn OPMDATA / paic1234; Error accessing PRODUCT_USER_PROFILE Warning:  Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected.

使用system用户登陆执行$ORACLE_HOME/sqlplus/admin/pupbld.sql 脚本即可

 > sqlplus system/paic1234

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Mar 6 16:45:22 2017

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, Data Mining and Real application Testing options

SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql DROP SYNONYM PRODUCT_USER_PROFILE              * ERROR at line 1: ORA-01434: private synonym to be dropped does not exist

  DATE_VALUE FROM PRODUCT_USER_PROFILE                   * ERROR at line 3: ORA-00980: synonym translation is no longer valid

DROP TABLE PRODUCT_USER_PROFILE            * ERROR at line 1: ORA-00942: table or view does not exist

ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG) * ERROR at line 1: ORA-00942: table or view does not exist

Table created.

DROP TABLE PRODUCT_PROFILE            * ERROR at line 1: ORA-00942: table or view does not exist

DROP VIEW PRODUCT_PRIVS * ERROR at line 1: ORA-00942: table or view does not exist

View created.

Grant succeeded.

Synonym dropped.

Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE              * ERROR at line 1: ORA-01434: private synonym to be dropped does not exist

Synonym created.

Synonym dropped.

Synonym created.

再次连接,不报错了 SQL> conn OPMDATA / paic1234; Connected.