添加过程：
使用sys用户在sql*plus执行
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 25 04:49:02 2017Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
SQL> @/u01/app/oracle/product/11.2.0/dbhome_1/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@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 25 04:49:35 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn scott/tiger
Connected.
SQL> show user
USER is "SCOTT"
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30782175/viewspace-2138515/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- df -h无响应或者卡住
- Error:service '?' unknown
- DMIS Add-on terminated during phase DDIC_ACTIVATION
- 开启SAP JAVA系统应用日志归档
- DB6ADM SQL30082N security processing faild with reason 17 SQLSTATE=08001
- SQL5099N reason code "4" SQLSTATE=08004
- SQL0727N AN error occurred during implicit system action type "3"
- unable to create account user="sapadm" 3004-703 return code 22
- DB2 rollforward 命令使用详解
- mount.nfs: Remote I/O error
