在oracle数据库实例中,刚刚创建的用户scott,登录时报告如下错误:
sys@CNHTM> conn scott/tiger Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected. |
这里提示要以system用户运行pubbld.sql脚本。
[@more@]用system用户登录
sys@CNHTM> conn system/oracle Connected. |
运行pupbld.sql
pupbld.sql脚本在$ORACLE_HOME/sqlplus/admin目录下,文件名为小写(在unix/Linux)中要注意文件名大小写
system@CNHTM> @?/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-00942: table or view does not exist 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. DROP PUBLIC SYNONYM PRODUCT_PROFILE * ERROR at line 1: ORA-01432: public synonym to be dropped does not exist Synonym created. DROP SYNONYM PRODUCT_USER_PROFILE * ERROR at line 1: ORA-01434: private synonym to be dropped does not exist Synonym created. DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE * ERROR at line 1: ORA-01432: public synonym to be dropped does not exist Synonym created. system@CNHTM> |
再次用scott用户登录,已经正常
system@CNHTM> conn scott/tiger Connected. scott@CNHTM> |
--end--
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22049049/viewspace-1031364/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22049049/viewspace-1031364/