ITPub博客

首页 > 数据库 > Oracle > oracle手工建库后建立scott用户的emp表,conn scott/tiger报错解决

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

原创 Oracle 作者:ywxj_001 时间:2016-04-01 20:15:41 0 删除 编辑
[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博客 ” ,链接:https://blog.itpub.net/22996654/viewspace-2073933/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: ocm的路上好累
请登录后发表评论 登录
全部评论
在零售、金融、互联网行业从事数据库相关工作10余年,有丰富的数据库管理和架构的相关经验。 涉及SQLServer、Oracle、MySQL、PostgreSQL等多种数据库。 目前在一家互联网公司担任DBA经理。 负责整个集团数据库的架构设计和管理工作。

注册时间:2010-01-19

  • 博文量
    247
  • 访问量
    436195