oracle手工建库后建立scott用户的emp表，conn scott/tiger报错解决

[oracle@oracledb ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 1 20:10:30 2016


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


SQL> conn /as sysdba;
Connected.
SQL> @?/rdbms/admin/utlsampl.sql
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracledb ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 1 20:01:11 2016


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


SQL> 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.
SQL> conn system/oracle;
Connected.
SQL> @?/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> 
SQL> 
SQL> 
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@oracledb ~]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 1 20:01:53 2016


Copyright (c) 1982, 2009, Oracle.  All rights reserved.


SQL> conn scott/tiger;
Connected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22996654/viewspace-2073933/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22996654/viewspace-2073933/