oracle手工建庫後建立scott使用者的emp表,conn scott/tiger報錯解決

ywxj_001發表於2016-04-01
[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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章