Oracle 10g ,創(chuàng)建完用戶之后報warning

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

使用system用戶登陸執(zhí)行$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 ProductionWith 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.