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.
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle scott/tiger的由來Oracle
- oracle 10g 手動建立scott(tiger) schemaOracle 10g
- Oracle通過scott使用者中的emp練習單表操作Oracle
- Oracle 12c 建立 SCOTT 使用者Oracle
- Oracle 12c如何建立scott使用者Oracle
- 建立scott使用者及物件物件
- Oracle資料庫scott使用者建立view檢視許可權Oracle資料庫View
- Oracle-解鎖scott賬戶Oracle
- 【Oracle】scott使用者下表結構、初始化資料和建表語句Oracle
- Oracle裡scott的由來Oracle
- 以scott使用者執行set autotrace 出錯
- 恢復oracle的scott使用者初始狀態操作Oracle
- Strace sqlplus scott/tiger@yws 很好處理tns問題SQL
- 手工建庫成功後用其他使用者登入報的一個錯誤
- 使用alter session set current_schema=scott用explain plan for檢視scott使用者的sqlSessionAISQL
- 新增scott使用者與其物件物件
- oracle基表使用小記(一)_更新col$調整scott使用者表test的排列次序Oracle
- 【手工建庫】手工方式建立 ORACLE資料庫全程記錄Oracle資料庫
- 向資料庫中新增HR使用者和SCOTT使用者資料庫
- oracle之 手動建立 emp 表 與 dept 表Oracle
- 關於oracle 預設示例scott的指令碼Oracle指令碼
- ORACLE11g DataGuard手工建立錯誤的解決方案(一)Oracle
- ORACLE11g DataGuard手工建立錯誤的解決方案(二)Oracle
- 【oracle手工建庫】Oracle
- oracle手工建庫Oracle
- Talk with Mr. Scott (轉)
- oracle 10 手工建庫Oracle
- Oracle 9 手工建庫Oracle
- Oracle手工建庫指南Oracle
- Oracle學習系列—Oracle表空間和使用者的手工建立Oracle
- 建庫時EM報錯的解決辦法
- Oracle 手工建立資料庫Oracle資料庫
- 手工建立oracle資料庫Oracle資料庫
- Oracle 9 手工建庫(轉)Oracle
- 手工建立oracle資料庫(轉)Oracle資料庫
- 為什麼我的logminer分析不出scott使用者的dml操作?
- Scott使用者及其物件和資料初始化指令碼物件指令碼
- 手工建立oracle資料庫的過程Oracle資料庫